2012-07-17 (first published: 2007-11-21)
2,241 reads
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: 2006-03-16)
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: 2006-03-16)
86 reads
Blogs
T-SQL Tuesday Retrospective #005: Reporting
A few weeks ago, I began answering every single T-SQL Tuesday from the beginning....
Daily Coping 25 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Database DevOps Deployment to Azure–Webinar
By Steve Jones
You can register now, but on Dec 3, I have a webinar with Microsoft...
Forums
How to know which index is invalid index on a table?
There are about thirty fields in a table SaleOrderLines, I created some indexes ,...
Thanksgiving 2020
Comments posted to this topic are about the item Thanksgiving 2020
Thanksgiving Visualizations
Comments posted to this topic are about the item Thanksgiving Visualizations
Ask SSC