Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New SQL Server Blog Post Tip...Passing tables as paramet
Message
From
26/10/2013 22:23:37
John Baird
Coatesville, Pennsylvania, United States
 
 
To
26/10/2013 18:53:17
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01586466
Message ID:
01586480
Views:
51
>>http://kevin_s_goff.typepad.com/kevin_s_goff_weblog/2013/10/10262013-transact-sql-tip-of-the-week.html
>>
>>Going to start doing this on my blog - going to try to do one a week.
>>
>>The topic this week: passing tables as parameters to stored procedures
>>
>>Over the years, SQL database developers have used many different techniques for trying to pass a variable number of key values to a procedure.
>>
>>Options have included CSV strings, XML strings, temporary tables, and (yuck) cursors.
>>
>>All of them work (though cursors are the worst) - however, in SQL 2008, Microsoft added a new table type, so that developers could pass table variables (declared as table type templates) to stored procs.
>>
>>Hope people find it helpful.
>
>Just want to jump in here to say that it was your Bakers Dozen explanation of TVPs in Code Magazine that got me started using them. As I told you at the time it was so clearly explained I instantly could see their usefulness. Used them extensively at Dow Jones to handle some things that would otherwise have been terribly cumbersome.
>
>Anyone who isn't familiar with or comfortable using Table Valued Parameters in SQL 2008 should jump on everything Kevin has written on this (and also look for posts by sqlDenis and possibly Naomi N. on lessthandot) Once you start using them you will think of many ways to refactor stuff you've done before.

How can you combine Naomi and Kevin in the same sentence?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform