Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New SQL Server Blog Post Tip...Passing tables as paramet
Message
De
26/10/2013 22:23:37
John Baird
Coatesville, Pennsylvanie, États-Unis
 
 
À
26/10/2013 18:53:17
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01586466
Message ID:
01586480
Vues:
48
>>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform