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

2004-11-04 (first published: )

391 reads

Blogs

Daily Coping 28 Sep 2022

By

Today’s coping tip is let go of other people’s expectations of you. I think...

SQL Server In Place Upgrades

By

Good morning dear blog reader. Today’s episode is fresh from a great weekend with...

Daily Coping 27 Sep 2022

By

Today’s coping tip is take your time. Make space to just breathe and be...

Read the latest Blogs

Forums

SQL inplace upgrade from sqlexpress to standard edition in VM Google cloud

By RK2012

Hello Team, planning to do SQL in place upgrade from sql2016express to sql2016 standard...

SQL Master Data Services 2019 - Website keeps prompting for login

By Pete Bishop

I have two SQL 2019 servers running Master Data Services which are continually prompting...

Add more columns to output

By Bruin

$msg = Get-Content 'C:\miscjunk\SQL_Servers.txt' | ForEach-Object {New-Object 'Microsoft.SqlServer.Management.Smo.Server' $_} | Select-Object -Expand Databases |...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers