Pass an Array into a Stored Procedure

Have you ever wished T-SQL allowed you to pass an array into a stored procedure? Well the spListToTable stored procedure listed below accepts a delimeted string and turns it into a table. Code your stored procedure to accept a varchar, create a temporary table, call spListToTable, and use the populated temporary table as if it […]

4.25 (4)

2001-12-10

2,838 reads

Blogs

SQLSaturday Orlando 2021 – September Update

By

Just over 30 days until SQLSaturday Orlando and I’m using some vacation time today...

Audit Columns

By

One of the easiest ways to collect information about table activity is to add...

Daily Coping 28 Sep 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Social Media Link Aggrigator

By suvina

Need a way to put all of your social media links and profiles into...

Implicit conversion from datetime to datetime2

By Alessandro Mortola

Comments posted to this topic are about the item Implicit conversion from datetime to...

Connect to SAP HANA Data as a Linked Server

By JerodJ

Comments posted to this topic are about the item Connect to SAP HANA Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers