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 |
|
klara
Starting Member
3 Posts |
 Posted - 2006-01-19 : 15:27:59
|
| I haven't touched MSSS in a looong timeWhen a SELECT returns say 3 rows what does the feedback say ?(eg Oracle/sqlplus says "3 rows selected")What if "no data found", what is the feedback ?thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-19 : 15:31:38
|
| Why not run a SELECT statement that you know won't return any rows? Such as:SELECT *FROM sysobjectsWHERE [name] = 'TaraKizerRules'Run that in Query Analyzer. It won't return any rows, so look at the "feedback".Tara Kizeraka tduggan |
 |
|
|
klara
Starting Member
3 Posts |
Posted - 2006-01-19 : 15:36:31
|
quote:
Originally posted by tkizer
Why not run a SELECT statement that you know won't return any rows? Such as:SELECT *FROM sysobjectsWHERE [name] = 'TaraKizerRules'Run that in Query Analyzer. It won't return any rows, so look at the "feedback".Tara Kizeraka tduggan
lol easy for you to say ;)I certainly would have done that instead of register and post, if I had access to SS right now. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-19 : 15:39:00
|
| If you don't have SQL Server, then why would you need this information? Is this for homework?Tara Kizeraka tduggan |
|
|
|
klara
Starting Member
3 Posts |
Posted - 2006-01-19 : 15:40:19
|
quote:
Originally posted by tkizer
If you don't have SQL Server, then why would you need this information? Is this for homework?Tara Kizeraka tduggan
oh boy...never mind Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-19 : 15:44:51
|
The "feedback" would be dependent on the SET NOCOUNT setting. When OFF:quote:
(0 row(s) affected)
When ON, you won't get any "feedback".Tara Kizeraka tduggan |
|
|
|
|
|
|
Server Feedback