Renu Mehta


Technical Article

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

You rated this post out of 5. Change rating

2006-04-19 (first published: )

376 reads

Technical Article

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

You rated this post out of 5. Change rating

2006-04-18 (first published: )

91 reads

Blogs

Tomorrow: Webcast on SQL Server security

By

Tomorrow, April 16, 2024, I will be giving another webcast; this one will be...

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Read the latest Blogs

Forums

Expression Error ( property 'Error' cannot be selected )

By rjdineen

Hello there. I have the following Pipeline I want to get the property error...

create cluster fails Win2016.

By snomadj

I'm installing a cluster prior to my 2019 SQL build.   Failover Cluster tools...

Dependency Cycle in Database with Update Approvals

By ahlembreath

I'm struggling with a dependency cycle in my SQL database schema. Here's the situation:...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers