Re: [转载] stored procedure 菜鸟一问, PLEASE HELP,在线等 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DotNet - 窗口里的风景

Re: [转载] stored procedure 菜鸟一问, PLEASE HELP,在线等

Re: [转载] stored procedure 菜鸟一问, PLEASE HELP,在线等# DotNet - 窗口里的风景

st2003-10-24 07:10

1 楼

of course, try that in your sql analyzer first,
select count(*) from user1 will return a number for the count(*)
that's one row, so you will get @[email protected]@ROWCOUNT, which is 1, :D

j*s2003-10-24 07:10

2 楼

Thank you so much!
In fact, there are 7 records in the table.
select count(*) from user1;
it will show 7.
So how can I set 7 to @num?
thanks

copy
procedure,

【在 st 的大作中提到】

: of course, try that in your sql analyzer first,
: select count(*) from user1 will return a number for the count(*)
: that's one row, so you will get @[email protected]@ROWCOUNT, which is 1, :D

st2003-10-24 07:10

3 楼

select @num=count(*) from user1
this is rather a sql question instead of C# question. :D

【在 j****s 的大作中提到】

: Thank you so much!
: In fact, there are 7 records in the table.
: select count(*) from user1;
: it will show 7.
: So how can I set 7 to @num?
: thanks
:
: copy
: procedure,

j*s2003-10-24 07:10

4 楼

Thanks, I got it, :-)

【在 st 的大作中提到】

: select @num=count(*) from user1
: this is rather a sql question instead of C# question. :D