我正在为寻呼目的编写动态查询。 下面是可执行查询的最后一部分,当我打印它并在不同的窗口运行时它工作正常。 但是当我使用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
更多推荐
发布评论