2012-07-17 (first published: 2007-11-21)
2,245 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)
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: 2006-03-16)
88 reads
Blogs
RMOUG Training Days in Denver
By Steve Jones
Next week I’m heading to the Lowry Conference Center in Denver for the RMOUG...
Daily Coping 7 Feb 2023
By Steve Jones
Today’s coping tip is to go to bed in good time and allow yourself...
Tales From The Field Weekly Wrap Up for the Week of 01-31-2023
By SQLBalls
Hello Dear Reader! After a weekend with a lot of activities, it was a...
Forums
What are the alternatives of S3 Object Lambda?
Hi all! AWS has a good example of how to manipulate the requested objects...
SQL Script plug-in
Is the SQL Script plug-in listed here no longer available? SQL Scripts in SSMS...
Modify RDS page missing the Storage Autoscaling option
Hi folks, I have a single Postgres instance on RDS that in the past...
Ask SSC