小的细节记录-sql模糊匹配中含有变量

use lianxi
GO

DECLARE @Key VARCHAR(200)
DECLARE TmpCursor CURSOR FOR SELECT K
              FROM HZ
OPEN TmpCursor
FETCH NEXT FROM TmpCursor INTO @Key
WHILE (@@FETCH_STATUS=0)
BEGIN
    DECLARE @Tmp VARCHAR(200)
    SELECT @Tmp = (SELECT count(*) FROM  POI where poi like '%'+@key+'%' ) 
     print @key+'#'+@Tmp              
    FETCH NEXT FROM TmpCursor INTO @Key
END
CLOSE TmpCursor
DEALLOCATE TmpCursor 

其中：红色部分的格式为要注意的细节，在模糊匹配中如果含有变量，用,分开，print如果想将两个值打印在同一行可以用+连接。