T-SQL

External Article

Swap column data due to inserting data into wrong columns for SQL Server table

  • Article

This article is for newbies who have just started their career in SQL development. Everyone might have faced this problem when importing or inserting data into tables when they accidentally put the data in the wrong columns. The first thought would be to delete the data and start over, but in this tip we look at a simple solution to swap the data.

2009-05-13

2,356 reads

SQLServerCentral Article

ROW_NUMBER(): An Efficient Alternative to Subqueries

  • Article

The ROW_NUMBER function has drastically changed the way we can write a number of queries in T-SQL. New author Francis Rodrigues brings us a few places where this function can improve the efficiency of your code.

4.52 (122)

You rated this post out of 5. Change rating

2010-01-29 (first published: )

72,795 reads

Blogs

Limiting Results with TEXTSIZE in SQL Server: #SQLNewBlogger

By

There is a SET command in SQL Server that changes how much data is...

Secret management using Pulumi ESC SDK and Azure Key Vault

By

This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...

The Book of Redgate–Being Reasonable

By

As a part of the Book of Redgate, we have a series of (red,...

Read the latest Blogs

Forums

install sql express

By sqlfriend

I yesterday dowload a sqlexpress and intalled on one of a testing database for...

The User Login

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The User Login

Using Feature Flags

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Using Feature Flags

Visit the forum

Question of the Day

The User Login

When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?

See possible answers