Passing Arrays or Tables as Parameters to a Stored Procedure

home
database
view story

2 Kicks

Passing Arrays or Tables as Parameters to a Stored Procedure(weblogs.sqlteam.com)

submitted by jimrice14(880) 4 years, 11 months ago

SQL is a set-based language, and often we wish to pass sets of data as a parameter to a stored procedure. For example, you might wish to pass a set of Customers to an invoice generating stored procedure, or a set of employees which for you’d like to calculate a particular bonus. There doesn't seem to be an easy way to accomplish this in T-SQL, but here's a simple technique that you might want to look at.

add a comment |category: Database |Views: 11
Tweet