st
发帖数: 1685 | 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 @num=@@ROWCOUNT, which is 1, :D | j****s
发帖数: 34 | 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 @num=@@ROWCOUNT, which is 1, :D
| st
发帖数: 1685 | 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****s
发帖数: 34 | 4 Thanks, I got it, :-)
【在 st 的大作中提到】
: select @num=count(*) from user1
: this is rather a sql question instead of C# question. :D
|
|
