Pass several sets of parameters to run stored proc

    This procedure will let you execute existing stored procedure with several sets of multiple parameters    like: exec _ParamSplit_SP 'ColorSP', "258,'RED';367,'BLUE';125,'GREEN'",";"    it will be the same as    exec ColorSP 258,'RED'    exec ColorSP 367,'BLUE'    exec ColorSP 125,'GREEN'Created for SQL 7

2002-04-03

845 reads

Blogs

What the ???? T-SQL Tuesday #120

By

Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...

First Time Speaking at PASS Summit

By

This week, I filmed my experience as a first time speaker at PASS Summit...

Azure SQL Best Practices?

By

A way to enforce good practice and standards is by Azure Policy. As stated...

Read the latest Blogs

Forums

SQL View - Pivot

By bbranco

I have the following data in a table, its pricing for items, so if...

does WITH (NOLOCK) hint in Select statement really make a difference?

By VoldemarG

In any regular Select query joining a few tables like below, does using this...

Query

By jsshivalik

Hi Table 1 AccountId Name 1101 aaaa 1701 bbbb Table 2 TransId Account Debit...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers