Technical Article

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

You rated this post out of 5. Change rating

2002-04-03

852 reads

Blogs

T-SQL Tuesday #180: Good enough is perfect

By

How can you achieve good enough without compromising the process/product? In the world of...

How to Convert FileTime to DateTime

By

One of my customers recently wanted to rename each of the SQL audit files...

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Read the latest Blogs

Forums

Closest to ProcDate

By boehnc

Not sure I have this 2nd left join correct. I need to grab the...

How to use a date range to open up a report?

By NineIron

The report that I want to open has an "ExamDate". I am trying to...

SQL estate future planning

By goodtimecharlie

Morning all, I've inherited a small (on prem) SQL estate.  I'm a DBA, used...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers