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

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

88 reads

Blogs

Container Limits and SQL Server

By

Limits in Containers Docker gives you the ability to control a container’s access to...

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Read the latest Blogs

Forums

Do You Have ALL the YAML?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have ALL the...

Why Power Query as an Activity in Azure Data Factory and SSIS?

By diponkar.paul

Comments posted to this topic are about the item Why Power Query as an...

Azure Blob Store Redundancy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure Blob Store Redundancy

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers