Unless you are placing this code in a stored procedure, you could just as well do this:SELECT *FROM ( SELECT 'A1' AS String1,'B1' AS String2, GETDATE() AS DateCol UNION ALL SELECT 'A2','B2', GETDATE()) AS dORDER BY And then append the sanitized column name to sort...

COALESCE in SQL Server

by sandeepmittal11

COALESCE in SQL Server

Code Generator for SQL Server

by Homero Ibarra Ramírez

Tool on T-SQL to code basic generator for SQL Server

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

by Ahmad A.A. Ahmad

Combining MDX with T-SQL in One Result Set for SSRS (Hybrid Query)

Consistent Hash function for SQL Server and .NET

by Pascal Ganaye

Provides a couple of hash functions (string to int) that will return the same value in C# and T-SQL

Cool Insert Generator

by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

Create Insert SQL Statement from the Records in an Existing Table

by markkang

This tip describes how to generate insert SQL statement from the records in an existing table in SQL server database

Create Query Shortcuts in SQL Server Management Studio

by saddam_msp

Shortcuts to execute your query faster while working or debugging T-SQL statement

Data Change Tracking Solution for Auditing SQL Server

by Bart Ducal

Universal data change tracking solution for auditing SQL Server databases

Default keyword in SQL Server

by Mel Padden

Default keyword in SQL Server

Deleting Users With No Database Mappings

by Darek Danielewski

A small script to remove old user accounts

DROP IF EXISTS in SQL Server 2016

by Jovan Popovic(MSFT)

SQL Server 2016 introduces the new DROP IF EXISTS syntax

Efficient paging using SQL script

by Robby Tendean

How to create an efficient paging using SQL script

Efficient paging using SQL script

by NeoPunk

Hi, what about such solution?DECLARE @pageNumber INTDECLARE @rowsOnPage INTSET @rowsOnPage=5SET @pageNumber=2DECLARE @totalItemsToSelect INTSET @totalItemsToSelect=@rowsOnPage * @pageNumberSELECT TOP (@rowsOnPage) * FROM MainTrans WHERE ID IN( SELECT TOP...

Efficient paging using SQL script

by jeantoledo

Take a look at this:DECLARE @ActualRow = 1; /*Start in first item*/DECLARE @ItensCount = 100; /*100 itens for page*/DECLARE @Page = 1; /*Start in first page*/SELECT * FROM(SELECT *, ROWNUMBER() OVER(ORDER BY Name) as ROWNUM FROM Users) as UsWHERE ROWNUM BETWEEN...

Efficient paging using SQL script

by kamiktk123

string Query = string.Format(@"SELECT * FROM (SELECT *, " + @"ROW_NUMBER() OVER(ORDER BY PRODUCT_ID DESC ) AS ROW_NUM FROM({0}) " + @"AS TEMP_INNER) AS TEMP_OUTER WHERE ROW_NUM BETWEEN '{1}' AND " + @"({2} + {3}) - 1", strSql, startRowIndex, startRowIndex, maximumRows);

Find progress of a database restore using sys.dm_exec_requests

by Liju Sankar

Find progress of a database restore using sys.dm_exec_requests

Find Which Column in Which Table Updated from logfile

by Mehdy Moini

How to know which table is updated in the current logfile time.

Forgot Password With Check Email From Database

by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Generate a Table Variable from Query Metadata

by Michael Selector

A code to declare a table variable which will be populated from a query

Generate Insert Scripts of Existing Rows with "if Exists" Conditions

by Chetan Naithani

Stored Procedure to Generate Insert Scripts

Generating HTML Reports for Dynamic Table Structures

by Sergii Syrovatchenko

This tip describes the most convenient way of process automation of generating HTML reports for dynamic table-structures and sending them to different people.

Hierarchical Query in Database

by Shamim Uddin

We will learn about hierarchical query in database with real example.

Holidays Table and GetWorkDays Function in SQL Server

by Igor Krupitsky

Fast function that excludes weekends and holidays

How to Calculate the Length of the Largest Text Value in Every Table Column

by Daniel Miller

This tip shows how to display the length of the longest string value in every table and column in your database.

How to Check Opened Connection in SQL Server

by Najmul Hoda

Here is the code snippet to check how many database connections are opened in SQL Server.

How to Create and Use a Self-referencing Hierarchical Table

by E. Scott McFadden

This article explains how to create and use a self referencing key in a SQL Server Table.

How to Get Words Separated in a String Concatenated by Delimiter

by Ankur .K. Vishwakarma

This tip shows you a T/SQL function to split a string concatenated by a delimiter.

How to Pass Calculated Columns in the WHERE & GROUP BY clause in T-SQL..?

by Bhushan W. Juare

Passing calculated columns in the Where and Group by clause in T-SQL

How to Perform Pivot Operation in T-SQL..?

by Bhushan W. Juare

This tip discusses how to perform pivot operations in T-SQL.

How to Publish ASP.NETCore MVC Web Application to IIS in Less Than 5 Minutes

by O.Nasri

A good tutorial in how you can publish your ASP.NETCore MVC web application to IIS.

How to Remove SSAS(Cube) Dimension Members Using Except() Function?

by Bhushan W. Juare

Removing SSAS(cube) dimension members using Except() function

Improving Backup Performance

by Satnam Singh CapGemini

Improving backup performance

INSERT script from Microsoft SQL table data

by GuruprasadV

The trick shows how to generate the INSERT script for each line of table data

INSERT script from Microsoft SQL table data

by Deep In The Code

IF OBJECT_ID('sysGenerateInsert','P') IS NOT NULLBEGIN DROP PROC sysGenerateInsert PRINT 'sysGenerateInsert SP successfully dropped'END GO CREATE PROC sysGenerateInsert(@TblName varchar(128))ASBEGIN ----------------------------------------------------------------- --...

Installing a CLR Stored Procedure on SQL Server

by Sarkis Matossian

The steps to install a CLR Stored Procedure in SQL Server

Installing a SQL Server CLR Stored Procedure as a Hex String

by Sarkis Matossian

Encoding a .NET assembly as a hex string to install in SQL Server.

Is MS SQL Server Service Broker Responding to Read Uncommitted Data?

by Herman.Instance

When using SqlDependency, is it possible that a detected change leads to 0 rows in the SqlDependency results?

Issues after Upgrade to SQL Server 2017 – Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

by Satnam Singh CapGemini

Cannot Bulk Load Data Into the Table with Primary Key Constraint on it

Lead and Lag Functions in SQL Server

by sandeepmittal11

Lead and Lag Functions in SQL Server

LTRIM RTRIM doesn’t always work

by Israel Cris Valenzuela

LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed

LTRIM RTRIM doesn’t always work

by PIEBALDconsult

In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...

Monitoring SQL Agent with Alerts for Long Running Jobs

by Member 14691410

Providing admin with an alert mechanism via an SP

Move Database File from One Drive to Another Drive

by User-12551084

Moving database file from one drive to another drive

MS SQL Server - SQL Object Dependency Check

by GuruprasadV

Check if dependency of a table are objects referenced by a stored proc. A system table with CTE can help to identify dependency quickly.

Parse Key Value Pairs from string in SQL

by Sumit Chawla

Describes how to parse and extract key value pairs from a string or column in SQL

Pay Attention to What "Script...To" Generates

by #realJSOP

It doesn't always happen the way you expect.

Pivoting on SQL Server Varchar Data Types

by Sifiso W Ndlovu

This tip illustrates a workaround to SQL Server pivoting on variable character data types.

Pure SQL solution to Database Table Paging

by DrABELL

Portable solution encapsulated in single SQL query allows to select N rows offsetting M records

Random Date/Time Test Data Generation

by Gene R. Browning

Generate random dates (and times if you like) for your test data environment.

Row_Number in SQL Server

by sandeepmittal11

Row_Number in SQL Server

Rowversion: Version Stamping A Row

by SonuKSingh

rowversion datatype in SQL Server: Track which row has been modified

R-script Migration to SQL Server 2016

by Evgeniy Sukhikh

Issues and solutions taken while moving R from cmd to sp_execute_external_script

Select Statement to HTML Table

by Luca Astolfi

User defined procedure for make an HTML table from T-SQL Select statment

Sequence Object in SQL Server 2012

by sandeepmittal11

A sequence is a user defined, schema bound object that generates a sequence of numeric values

sp_extendedproperty

by Paw Jershauge

An easy to use extendedproperty procedure (alternative to sp_dropextendedproperty, sp_addextendedproperty, sp_updateextendedproperty)

Split a String with Specific Separator Character

by Ngo Thanh Tung - Softech

T-SQL scripts: Write a table function to split a string with specific separator character

Split Any Delimited String in SQL

by Ksh_Sr

This tip shows how to separate a string with delimited characters.

Split Any Delimited String in SQL

by PIEBALDconsult

This is an alternative for "Split Any Delimited String in SQL"

SQL Deployment Tool for Multiple Databases

by Srinivas-Miriyala

Executes SQL scripts in multiple databases at once.

SQL Schema Support Multi Version Tables

by Simon Korenfeld

SQL schema with multi version tables support

SQL Script to Drop and Re-create All Foreign Keys in SQL Server

by Nitinpatel

This SQL script will generate a script to drop and create all foreign keys in database.

SQL Server - BLOB Import and Export

by mkader

SQL scripts to insert File to BLOB field and export BLOB to File

SQL Server Database Inventory using PowerShell

by Dathuraj Pasarge

Extract SQL Server DB inventory\baseline using TSQL and PowerShell scripts

SQL Server Grant Permission to Particular Table

by Shashangka Shekhar

In this post, we will create a new user in SQL Server Management Studio (SSMS) & allow access to that user to perform a specific operation.

SQL Server XIRR Function

by Michael Ecklin

This tip describes Microsoft SQL Server implementation of XIRR function.

SQL to ADO.NET API (Automated ADO.NET or DB API)

by dmytro.sen

SQL to ADO.NET API (Automated ADO.NET)

Subquery In T-SQL

by Bhushan W. Juare

Subquery in T-SQL

Template for Managing Microsoft T-SQL Nested Transactions

by brian_eckert

A proposed template for writing nested stored procedures that perform updates (inserts, updates, deletes)

The SQL Server Rand Function

by Pascal Ganaye

Reproducing the SQL RAND() function in C#

TrimChar to Remove Desired Character

by Wendelius

TrimChar function which removes occurences of the desired character from both ends of a string.

T-sql over clause to aggregating without groupby

by pankajupadhyay29

A nice way to get aggregated value without group by

T-SQL Simulator for Monty Hall Paradox

by Miljan Radovic

T-SQL Simulator for Monty Hall Paradox

T-SQL Way of Calculating Next n Business Days (Including Nominated Public Holidays and Weekends)

by Member 12574862

A new approach of calculating next N business days's date, provided we know the start date and the N number

Using SCOPE_IDENTITY with CommandBuilder and DataAdapter

by Antonino Porcino

How to use T-SQL function SCOPE_IDENTITY() to retrieve inserted rows identity values with CommandBuilders and DataAdapters

Ways to Compare and Find Differences for SQL Server Tables

by Michael Ecklin

Sometimes, we need to compare 2 tables to see what was changed. This tip shows you 2 different ways to compare data.

Who Logged In Using SA Credentials?

by Deepak A S

An ALL SERVER trigger to know who it is!

Yet another string splitter

by zvin

Splits string using TSQL, but a very simple technique using the XML datatype.