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

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

94 reads

Blogs

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Monday Monitor Tips: Using the PowerShell API

By

Redgate Monitor has grown tremendously from its early days and I find many customers...

Data Governance: The Invisible AI Accelerator

By

The post Data Governance: The Invisible AI Accelerator appeared first on Joyful Craftsmen.

Read the latest Blogs

Forums

Problem with the dll (version 1.2) of an Extended Stored Procedure with SQL Serv

By SKEITA

SQL Server 2022 16.0.4165.4 Windows Server 2022 Datacenter 21H2 20348.2849 Our Extended Stored Procedure...

PK violation in replication but only one subscriber

By cphite

We have a publication with three subscribers; it's basically a part list with around...

Recovery Takes 10-20 mins with ADR enabled

By VastSQL

Hi Experts, I have database about 300GB in size with ADR enabled but after...

Visit the forum

Question of the Day

Data API Builder Operations

What types of database operations does the Data API Builder support?

See possible answers