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

Restoring Backups from Azure Blob with dbatools

By

Recently I needed to write a PowerShell script that could build a backup set...

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Rownumber()

By GED.Burnett 71559

I need to get a rolling count only of rows matching a particular criteria...

https://thefitnessvibes.com/legendz-xl/

By Marciaboyd330

Legendz xl clairvoyantly female! The is a male steroid hormone created normally in men...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The typo

See possible answers