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: )

364 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: )

83 reads

Blogs

Do you have rarely used indexes that are hurting performance of writes?

By

We know that indexes are necessary for query performance but comes with overhead during...

Working with SQLSaturday SpeedPASSes – revamped!

By

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...

Happy Hour at SQL in the City Austin

By

Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

sql server 2012 data column used for 7 different languages

By wendy elizabeth

In a sql server 2012 database, I want to store some messages in the...

Table type

By Admingod

I just want to validate my use of a custom type. I'm doing a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers