Technical Article

Updating multiple rows using single stored proc

The situation arises when we are displaying data in a grid or some other control at front end level, where the user is making corresponding changes in the grid and at last when the user click for update button, the whole changes should be posted back to the database. This can be achieved by two […]

You rated this post out of 5. Change rating

2004-11-04 (first published: )

523 reads

Blogs

T-SQL Tuesday #186–Agent Jobs

By

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

SQL Saturday NYC Recap 2025

By

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By

Just a quick one this morning. I’m on the road and haven’t worked up...

Read the latest Blogs

Forums

SSIS Automatically Coverting a NULL to a Blank Space

By cpiacente

Hello, I was wondering if anyone knew how to prevent this issue I am...

Problem creating a Linked Server to MS Access 97 database from SQL Server 2019

By Weegee71

Hi there I need help on creating a Linked Server to an MS Access...

SSPI handshake failed error code 0x80090311

By jamesstirling01

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers