动态sql @FristNum char(8), @LastNum char(8), @AllNum char(8) AS DECLARE @SQL NVARCHAR(4000) SET @SQL='SELECT * FROM code WHERE (soccode like '+''''+@FristNum+'%'+@LastNum+''''+') AND (soccode<> '+@AllNum+ ') ORDER BY title'EXEC (@SQL)
SELECT * FROM code WHERE soccode like @FristNum + '%' and soccode like '%' + @LastNum AND soccode <> @AllNum ORDER BY title
-----------------------------------------------
你的方法是错的
@FristNum char(8),
@LastNum char(8),
@AllNum char(8)
AS
DECLARE @SQL NVARCHAR(4000)
SET @SQL='SELECT * FROM code WHERE (soccode like '+''''+@FristNum+'%'+@LastNum+''''+') AND (soccode<> '+@AllNum+ ') ORDER BY title'EXEC (@SQL)
*
FROM
code
WHERE
soccode like @FristNum + '%'
and
soccode like '%' + @LastNum
AND
soccode <> @AllNum
ORDER BY
title