Home >Database >Mysql Tutorial >sqlserver下调试sql语句

sqlserver下调试sql语句

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 15:39:301369browse

现在版本的sqlServer已经支持调试功能了,但是在使用的时候用到的却很少(毕竟print习惯了。。) 这里做一个笔记,简单的说明一下在sqlserver下调试的方法: declare @i int , @j int , @k int set @i = 1 ; set @j = 2 ; select @k = @i + @j select @k ; g

现在版本的sqlServer已经支持调试功能了,但是在使用的时候用到的却很少(毕竟print习惯了。。)

这里做一个笔记,简单的说明一下在sqlserver下调试的方法:

<span>declare</span> <span>@i</span> <span>int</span> ,<span>@j</span> <span>int</span>,<span>@k</span> <span>int</span>   
<span>set</span> <span>@i</span> <span>=</span> <span>1</span><span>;  
</span><span>set</span> <span>@j</span> <span>=</span> <span>2</span><span>;  
</span><span>select</span> <span>@k</span><span>=</span><span>@i</span> <span>+</span> <span>@j</span>  
 <span>select</span> <span>@k</span><span>;  
</span><span>go</span> 

按F11或者点击菜单栏的调试按钮即可开始调试

 

sqlserver下调试sql语句

按F10进入下一步

遇到存储过程的时候按F11可以进入存储过程调试

sqlserver下调试sql语句

sqlserver下调试sql语句

好了,感觉和vs的调试很相似

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn