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

844 reads

Blogs

Weekly reading #19

By

Good afternoon folks! It is Monday Tuesday already after a long weekend in Poland....

Azure SQL DB Maxdop Hint

By

I had a good question from JP via a comment on my blog about...

The Constant and Constantly Changing Role of the DBA

By

I’ve been working in and around data for over 30 years now. My title...

Read the latest Blogs

Forums

unable to install SQL Server 2014

By Srinivas Sista

Hi, I am trying the install SQL Server 2014 enterprise edition on Windows 2016...

What's the CMK?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the CMK?

All flash vs adaptive flash storage - which is right for my organisation?

By Stephen Wild

Comments posted to this topic are about the item All flash vs adaptive flash...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers