Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by AndyBates
-
Is there any way in a stored proced
Yes. Use the @@error object to check for errors after your insert\update code. if @@error <> 0 then an error has occured, you can return a message to the user to tell them the Insert\update has failed. See SQL server books online for more info on @@error. Andy- AndyBates
- Post #2
- Forum: Microsoft SQL Server: Programming
-
SQL Query Analyzer
Best bet is to choose to save the results of the query to text, from the Query menu in SQL Query Analyser. Execute your query, and the results will appear in your Query Analyser window, with the column headings. You can then copy and paste this into a text editor, or excel.- AndyBates
- Post #2
- Forum: Microsoft SQL Server: Programming
