SET NOCOUNT 的怪问题
<div style="padding-right: 5.4pt; padding-left: 5.4pt; background: #e6e6e6; padding-bottom: 4px; width: 95%; padding-top: 4px;">http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gifhttp://images.csdn.net/syntaxhighlighting/OutliningIndicators/ContractedBlock.gif/**//*--SETNOCOUNT的问题http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gifSQL版本:SQLServer20053159
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif故障描述:
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif当满足下述条件时,SETNOCOUNT导致TRY...CATCH无法正确处理错误
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif1.使用EXEC(<SQl>)AT<LinkedServer>或者EXEC<LinkedServer>.<databasename>.dbo.sp_executesql<SQl>
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif2.<SQL>中包括输出参数
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif3.<SQL>中包括SETNOCOUNTON和USE<DatabaseName>语句(注意不能更换出现次序)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif具体的参考下面的测试示例
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif与此问题相关的帖子:
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gifhttp://topic.csdn.net/u/20080103/12/3dafc07c-3376-40c1-b4bd-7cbd76afed1a.html?seed=182508736
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockEnd.gif--*/
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--添加链接服务器
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifEXECsp_addlinkedserver'srv_lnk','','SQLOLEDB','.'
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifEXECsp_serveroption'srv_lnk','rpcout','true'
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifGO
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--测试语句
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--SETNOCOUNTON
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifBEGINTRY
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDECLARE
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif@error_numberint,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif@error_messagenvarchar(2048)
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifEXEC(N'
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifSETNOCOUNTON
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifUSEtempdb
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifBEGINTRY
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifDELETEFROM
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifENDTRY
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifBEGINCATCH
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifSELECT
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif?=ERROR_NUMBER(),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif?=ERROR_MESSAGE()
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifENDCATCH
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif',
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif@error_numberOUTPUT,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif@error_messageOUTPUT
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif)ATsrv_lnk
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifENDTRY
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifBEGINCATCH
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifSELECT
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif2,
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifERROR_NUMBER(),
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifERROR_MESSAGE()
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifENDCATCH
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifGO
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif--删除链接服务器
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifEXECsp_dropserver'srv_lnk','droplogins'
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gifGO
http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif
页:
[1]