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 |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2006-07-12 : 00:45:05
|
| Any one help me out ?Thank you very much .! |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-07-12 : 00:50:23
|
| Have a read in books online at the entry for "SET NOCOUNT".That explains it pretty well, ask back if you have any other questions.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-07-12 : 02:29:25
|
| 1. Use QA2. ctrl+T3. SET NOCOUNT ON 4. execute any query5. SET NOCOUNT OFF6. execute the same query7. Compare the o/pHey pamyral_279 why you want rely on sql team guys? ;0)------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
The meaning of Set NoCount On and Off?