Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-14 : 13:00:26
|
| Maloy writes "Hi there,I read rocketscientist's reply to Yong's question on how to get the value of count(*) from a dynamic sql statement using sp_executesql.What u suggest is to create a temp table by selecting all records. But, I don't want to create a temp table at all, since the count may be quite huge.In that case, is there any way to reject the resultset and still get the value?tiaMaloy" |
|
|
|
|
|
how to reject resultset got from sp_executesql