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

451 reads

Blogs

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Power BI: Refreshable Excel Files in PBI Service

By

Ever since Excel made its debut in the 1980’s, it has been used as...

Read the latest Blogs

Forums

Help on grouping to sets of rows in my sql data

By Mond

Hello I need help on writing this query. This is what i need. I...

SSIS Connecting to Azure SQL Managed Instance w/ MFA

By tjcavins

We've been testing out Azure SQL Managed Instance and created SSIS packages to run...

Summarizing Raw Sales Data with Group Summaries and Final Summary

By Paul Stasny

Greetings, I need to transform data returned in a query from several tables as...

Visit the forum

Question of the Day

The Query Traceflag

If I want to enable a trace flag for a specific query, how do I do it?

See possible answers