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
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.
精彩评论