Renu Mehta


Technical Article

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 […]

You rated this post out of 5. Change rating

2006-04-19 (first published: )

376 reads

Technical Article

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 […]

You rated this post out of 5. Change rating

2006-04-18 (first published: )

91 reads

Blogs

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Read the latest Blogs

Forums

Closing a Symmetric Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Closing a Symmetric Key

I can query one by one. Need help how to become Single Query

By Adelia

Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...

Baking up and restores VLDBs

By ericwenger1

Some of our databases are getting be close to 2 terabytes. We are backing...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers