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

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

85 reads

Blogs

New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress

By

My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...

Step By Step Installation of SQL Server 2019 with all features

By

[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...

Read the latest Blogs

Forums

Career Advice: Data Warehouse Architect/Modeler

By @@caffeine_level

Maybe some of you would share your thoughts about my situation. I´m working in...

Avamar Backup--Is it good?

By VastSQL

Dear Experts, is it good to use Avamar backup for SQL Server, currently we...

Read-only

By curious_sqldba

  I read MSFT documentation few times but couldn't find a clear answer. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers