SqlServerKudos - Passing a TABLE variable into dynamic SQL | AdaTheDev

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Passing a TABLE variable into dynamic SQL | AdaTheDev

published 642 days, 5 hours, 19 minutes ago posted by

AdaTheDev 651 days, 14 hours, 48 minutes ago

Passing a TABLE variable into dynamic SQL | AdaTheDev

A question popped up on StackOverflow today, asking how to pass a TABLE variable into a dynamic SQL statement in SQL Server 2008. I've previously blogged about table-valued parameters, comparing the approach of passing in a TABLE of values to a stored procedure to the techniques you'd have had to use in earlier versions of SQL Server (e.g. CSV or XML), but this specific question is worth a quick follow-up.

category: Query | clicked: 1 | | source: www.adathedev.co.uk | show counter code

tags: SQL, SQL Server

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos