Table Generator for defined tables

This script will generate a format friendly ddl statement for a predefined table in sql server.

Views

T SQL

Rename objects

Swap column values

Interchange column values using a single update query

Queries with Aggregate Functions

CAST

ANSI_NULLS & QUOTED_IDENTIFIER

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

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.

ROW_NUMBER(): An Efficient Alternative to Subqueries

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.