开发者

visual studio 2010 error when execute step into stored procedure from server explorer on bit field

开发者 https://www.devze.com 2023-03-18 05:21 出处:网络
My stored procedure runs fine from sql studio as you can see from below screenshot, but when I tr开发者_JAVA技巧y to step into or execute from server explorer in visual studio I get error shown for th

My stored procedure runs fine from sql studio as you can see from below screenshot, but when I tr开发者_JAVA技巧y to step into or execute from server explorer in visual studio I get error shown for the bit field. What the hell am i doing wrong ? Right click on image and do view image for better picture. thank you

visual studio 2010 error when execute step into stored procedure from server explorer on bit field


It seems like visual studio can't handle 'bit'. Try to rewrite your stored procedure so @getcount is a tinyint or an integer. You could also try to write "true" instead of '1' in visual studio, with a bit of luck that could do the trick.

0

精彩评论

暂无评论...
验证码 换一张
取 消