Renu Mehta

All authors

Using DDL Trigger

by Renu Mehta

SQLServerCentral.com

DDL trigger

Using DDL Triggers

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2012-07-17 (first published: 2007-11-21)

2,256 reads

Discuss

Script to split a comma seperated string to table

by Renu Mehta

SQLServerCentral

Miscellaneous

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-04-19 (first published: 2006-03-16)

399 reads

Discuss

Script to find a particular string in procs/func.

by Renu Mehta

SQLServerCentral

Miscellaneous

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 […]