Table variables & Try Catch

Question

Post reply

Table variables & Try Catch

Mohan Kumar VS

SSCommitted

Points: 1724
More actions
November 22, 2010 at 5:56 am

#226908

Hi
Kindly let me know if we can use try catch block while inserting data in table variables...
Rgds
Mohan Kumar VS

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 1

Dave Ballantyne

SSC-Dedicated

Points: 33667

November 22, 2010 at 6:09 am

#1253685

Have you tried ?

Clear Sky SQL
My Blog[/url]

Mohan Kumar VS SSCommitted Points: 1724 More actions · Answer 2

Mohan Kumar VS

SSCommitted

Points: 1724

November 22, 2010 at 6:18 am

#1253694

Yes, I tried... It works.... Thanks for your reply...

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

WoW!!!

You're a genius Dave!!

Who else would have thought of doing that??? 😀

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

WayneS SSC Guru Points: 95460 More actions · Answer 4

Alvin Ramard (11/22/2010)
WoW!!!
You're a genius Dave!!
Who else would have thought of doing that??? 😀

LOL! (avatar applies here...)

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2