SQL - Do not return rows affected or row count

The following SQL command will prevent the query from returning rows affected numbers, etc. This is useful when piping the data into a text file. You can pipe using ">".

SET NOCOUNT ON

Additional Interesting Articles

Execute SQL From Command Line
Check For Value In Column In Multiple Table SQL
SQL Check Existence of Table or Temp Table
SQL Difference Between IS NULL and =NULL
Execute Files Remotely Using PSExec
C# Needle In Haystack String Replacements

©2008 AndrewKimball.com