动态SQL查询问题

动态SQL查询问题 - SQL Server(Dynamic SQL query Issue - SQL Server)

我正在为寻呼目的编写动态查询。 下面是可执行查询的最后一部分，当我打印它并在不同的窗口运行时它工作正常。 但是当我使用exec时，它会显示红色波形，用于铸造零件（CAST（@pint_StartRowIndex AS VARCHAR）），如附图所示。

谁能告诉我为什么我收到这个错误？ 如果我使用Print而不是Exec ，则不会出现错误，并且打印查询执行时没有错误。

I'm writing a dynamic query for paging purpose. below is the last part of the executable query and when i print it and run in different window it works fine. but when i use exec it shows red squiggle for casting parts (CAST(@pint_StartRowIndex AS VARCHAR)) as showing in attached image.

could anyone tell me why I'm getting this error? If i use Print instead of Exec it gives no errors and printed query execute with no errors.

最满意答案

试试这样：

exec ('SELECT * from table where Rank BETWEEN CAST ('+ @start + 'as nvarchar)' + ' AND cast (' + @end + 'as nvarchar)')

引用除了@start和@end之外的所有字符串

try like this :

exec ('SELECT * from table where Rank BETWEEN CAST ('+ @start + 'as nvarchar)' + ' AND cast (' + @end + 'as nvarchar)')

quote everything as string except @start and @end