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.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 How to check TSQL's EXECUTE command for error

Author  Topic 

yommy1831
Starting Member

10 Posts

Posted - 2013-07-11 : 19:39:30
Hello,

I am TOTALLY new with TSQL/SQL. consider the code below:

EXECUTE sp_executesql @sql, N'@xmldataOUT xml OUTPUT', @xmldataOUT=@instance OUTPUT;

CREATE XML SCHEMA COLLECTION FASSchema AS @instance

How can:
1. Add a check to the EXECUTE command to see if it fails
2. what is a suitable way to display an error message in case the EXECUTE command fails
3. Add a check to the CREATE command to see if it fails

Your help will be highly appreciated. I need people to jumpstart me

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-07-12 : 00:30:15
Duplicate threads:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186771
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=186769

--
Chandu
Go to Top of Page
   

- Advertisement -