荣耀彩票代理

IT技术互动交流平台

sql server2008里的调试存储该如何操作

作者:whl  来源:网络整理  发布日期:2018-11-17 08:44:00

ZUIJINHENDUOYONGHUHEXIAOBIANFANKUIZAISHIYONGQLSERVER 2005FAXIANDEBUGGERDEGONGNENGTURANZHAOBUDAOLE,JINGGUOJIANCHAZHIHOUFAXIANHAIXUYAOJINXINGDIAOSHICAINENGSHIYONG,FEICHANGMAFAN,YINCIDOUDASUANBAZHEIGEBANBENXIEZAILEZHONGXINANZHUANGGENGGAOJIDEBANBEN。SUIRANsql server2008LIZHEIGEGONGNENGSHIKEYISHIYONGDE,DANSHITADEDIAOSHICUNCHUGUOCHENGHEQITABANBENXIANGBIHAISHIFEICHANGBUYIYANGDE,XIAMIANDAJIAJIUYIQILAIXUEXIBA!

QIANYAN

SQLSERVER 2005ZHONGBUZHIYINHEQUDIAOLEHENZHONGYAODEDEBUGGERGONGNENG,YAODIAOSHI,BIXUYAOANZHUANGVS2005ZHUANYEBANHUOZHEGENGGAOBANBEN。FEICHANGBUFANGBIAN。

HAIHAO,SQLSERVER 2008ZHONGZHEIGEHENZHONGYAOERQIEFANGBIANDEGONGNENGYOUHUILAILE。

不过,SQLSERVER 2008的调试功能和SQL2000的方法差别很大。SQL2000是在查询分析器中的对象浏览器荣耀彩票代理中选中需要调试的存储过程,右键----调试---输入参数开始调试。

sqlserver2008ZHONGZEWANQUANBUTONG,BIANCHENGLEBIXUYAOZAISSMSZHONGEXEC [PROCEDURE NAME] @VAR1,@VAR2,RANHOUDIANLVSESANJIAOHUOZHEDIANCAIDANZHONGDEDIAOSHI---QIDONGDIAOSHI。RANHOUDIANGONGJULANDEZUIYOUBIANDEDANBUDIAOSHIHUOZHETIAOCHUDENG。

BENWENJIANGJIDAJIAXIANGXIJIESHAOGUANYUsql server2008DIAOSHICUNCHUGUOCHENGDEXIANGGUANNEIRONG,XIAMIANHUABUDUOSHUOLE,LAIYIQIKANKANXIANGXIDEJIESHAOBA

FANGFARUXIA

1、CHUANGJIANSUOXUYAODIAOSHIDECUNCHUGUOCHENG,BINGZHIXINGYIXIA,YEJIUSHIBAOCUNHAO ,WOYAOYANSHIDECUNCHUGUOCHENGMINGSHI “usp_Passport_GetNewDepositary”

usp_Passport_GetNewDepositary

荣耀彩票代理2、ZHAODAOCUNCHUGUOCHENG,YOUJIAN“ZHIXINGCUNCHUGUOCHENG”,HUIDANCHURUXIADEJIEMIAN,YAOSHURUCUNCHUGUOCHENGSUOYONGDECANSHU。

“执行存储过程”

3、CANSHUSHURUHOUDIANJIQUEDING,XITONGHUIWEINISHENGCHENGRUXIADEDAIMADAOBIANJIQIZHONG。

生成如下的代码

4、DIANJIGONGJUTIAOSHANGMIANLVSEDEXIAOSANJIAOJINRUDIAOSHIJIEMIAN,ZHUYI,ZHEILIYOUYIGEGUANJIANDIAN,DANGDAIMAZHIXINGDAOEXECZHEIYIXINGSHIYIDINGYAODIANJI“DIAOSHI” ---》“ZHUYUJU”,ZHEIYANGCAIHUIJINDAOZHEIGECUNCHUGUOCHENGZHONGQU。

进入调试界面

荣耀彩票代理5、JINQUHOUDEJIEMIANYERANGDAJIAKANYIXIABA,KEYIFANGBIANDEJIANKONGGECANSHUE。

监控各参数

SHANGMIANJIUSHIJINTIANYAOJIAFENXIANGDERUHEDUIsql server2008DEDIAOSHICUNCHUGUOCHENGJINXINGCAOZUODEXIANGXISHILILE,SHIBUSHIHENJIANDANNI?DAJIAKEYIGENJUSHANGMIANXIANGXIDENEIRONGLAIXUEXI,RUGUOHAIYOUSHENMEYIWENDEHUAJIUGANJINJIXIAOBIANLIUYAN,DAJIAYIQIJIAOLIUTAOLUNJIEJUEWENTI。

荣耀彩票代理ZHEIPIANWENZHANGZHUYAOJIDAJIAFENXIANGJIESHAOLEGUANYUsql server2008DIAOSHICUNCHUGUOCHENGDEWANZHENGBUZHOU,WENZHONGTONGGUOSHILIDAIMAJIESHAODEFEICHANGXIANGXI,DUIDAJIADEXUEXIHUOZHEGONGZUOJUYOUYIDINGDECANKAOXUEXIJIAZHI,XUYAODEPENGYOUMENXIAMIANSUIZHEXIAOBIANLAIYIQIXUEXIXUEXIBA。

 
Tag标签:      
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规