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 |
|
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 @instanceHow can:1. Add a check to the EXECUTE command to see if it fails2. what is a suitable way to display an error message in case the EXECUTE command fails3. Add a check to the CREATE command to see if it failsYour help will be highly appreciated. I need people to jumpstart me |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|
|
How to check TSQL's EXECUTE command for error