Technical Article

Update multiple rows (in a set) using a single SP

Here is another variation of processing multiple records with a single procedure call but allowing for set processing.The helper functions make use of the sequencetable pattern. These helper functions can be used to parse strings into records, so one gets a list, or simply return the nth field.There are two functions that will parse into […]

2004-12-17 (first published: )

768 reads

Blogs

Tell My Story of Public Speaking

By

This month the fine folks behind New Stars of Data and the DataGrillen Newcomer...

The Last Trip of 2022

By

It’s the last trip for me today. I head to the UK for a...

How to cluster SAP ASCS/SCS with SIOS DataKeeper on VMware ESXi Servers

By

This article describes the steps you take to prepare the VMware infrastructure for installing...

Read the latest Blogs

Forums

Exporting from SQL to XML issue

By Jobs90312

Hi everyone, So I have a table which consists of different IDs of a...

I need a user from non-prod-rds.amazonaws.com instance replicated to Prod RDS

By bvjkishore.mssql

Hi Team, I need a user from non-prod-rds.amazonaws.com MSSQL instance replicated with the same...

DateTime Format Conversion AM/PM

By HeftSteady

Hi,   I have a field showing select field from table ; 2022-11-28 16:19:38...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers