Renu Mehta


Script to split a comma seperated string to table

Requirement:Multiple Customers were selected from a interface created in VB. A stored procedure was created which accepts the customer codes as a parameter in the form of 100,200,300,400. Wanted to fetch the information for only those customers selected. Ideally we will have to create a dynamic SQL which would be somewhat like this Set @StrSQL […]

2006-04-19 (first published: )

372 reads

Script to find a particular string in procs/func.

Requirement:I added a parameter to an existing user defined function. This user-defined function was used in many procedures across system. Whenever a parameter is added to a user defined function, then we will have to change the calling of the function and pass the value for the new parameter added. Even though the parameter is […]

2006-04-18 (first published: )

86 reads

Blogs

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Daily Coping 26 Oct 2020

By

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

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Read the latest Blogs

Forums

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Recovering Databases From a Master Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Recovering Databases From a Master...

The Next Evolution of Big Blue

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Next Evolution of Big...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers