visual studio 2010 error when execute step into stored procedure from server explorer on bit field
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.
精彩评论