to 楼上大哥: 还是不行啊 反正一旦遇到更新操作的语句就无法获得记录了,如果是select则没有问题
Create Proc Test @aa varchar(10), @bb varchar(100) As set nocount on--add Update table1 Set col1='aa' Select 1,2,1,2,32,3234,4,435,345345,435,34534,345345,23Return
Create Proc Test @aa varchar(10), @bb varchar(100) As set nocount on Update table1 Set col1='aa' set nocount off Select 1,2,1,2,32,3234,4,435,345345,435,34534,345345,23Return
还是不行啊
反正一旦遇到更新操作的语句就无法获得记录了,如果是select则没有问题
@aa varchar(10),
@bb varchar(100)
As
set nocount on--add
Update table1 Set col1='aa' Select 1,2,1,2,32,3234,4,435,345345,435,34534,345345,23Return
@aa varchar(10),
@bb varchar(100)
As
set nocount on
Update table1 Set col1='aa'
set nocount off Select 1,2,1,2,32,3234,4,435,345345,435,34534,345345,23Return