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

SQL

HTML

T-SQL

XML

SQL-Server

reporting

Forgot Password With Check Email From Database

22 Oct 2013 by Muhammad Aqib Shehzad

Forgot Password and Email Check from Database

Rowversion: Version Stamping A Row

19 Oct 2013 by SonuKSingh

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

Cool Insert Generator

26 Sep 2013 by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

Find Which Column in Which Table Updated from logfile

12 Sep 2013 by Mehdy Moini

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

T-SQL

SQL-Server

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

16 Jun 2013 by Bhushan W. Juare

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

T-SQL

Subquery In T-SQL

16 Jun 2013 by Bhushan W. Juare

Subquery in T-SQL

T-SQL

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

16 Jun 2013 by Bhushan W. Juare

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

T-SQL

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

13 Jun 2013 by Bhushan W. Juare

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

T-SQL

Build a Date Function

26 Nov 2012 by André Kraak

This is an alternative for "Build a Date Function"

T-SQL

SQL

Build a Date Function

23 Nov 2012 by Rob Branaghan

Just a function to make populating a datetime variable easier!

T-SQL

SQL

Pure SQL solution to Database Table Paging

15 Aug 2012 by DrABELL

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

Parse Key Value Pairs from string in SQL

7 Jul 2012 by Sumit Chawla

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

SQL Server - BLOB Import and Export

24 Apr 2012 by mkader

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

A simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

27 Mar 2012 by Marian Placko

This article shows a simple hack of a built-in MS SQL Server WITH ENCRYPTION mechanism

LTRIM RTRIM doesn’t always work

18 Feb 2012 by Israel Cris Valenzuela

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

T-SQL

SQL

stored-procedure

LTRIM RTRIM doesn’t always work

16 Feb 2012 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...

T-SQL

SQL

stored-procedure

The SQL Server Rand Function

8 Feb 2012 by Pascal Ganaye

Reproducing the SQL RAND() function in C#

T-SQL

SQL-Server

Efficient paging using SQL script

16 Jan 2012 by Robby Tendean

How to create an efficient paging using SQL script

T-SQL

SQL

SQL-Server

Efficient paging using SQL script

10 Jan 2012 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);

T-SQL

SQL

SQL-Server

Efficient paging using SQL script

10 Jan 2012 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...

T-SQL

SQL

SQL-Server

Efficient paging using SQL script

28 Dec 2011 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...

T-SQL

SQL

SQL-Server

MS SQL Server - SQL Object Dependency Check

4 Dec 2011 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.

T-SQL

debugging

analysis

Using SCOPE_IDENTITY with CommandBuilder and DataAdapter

23 Nov 2011 by Antonino Porcino

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

Consistent Hash function for SQL Server and .NET

26 Oct 2011 by Pascal Ganaye

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

Yet another string splitter

2 Oct 2011 by zvin

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

T-SQL

INSERT script from Microsoft SQL table data

6 Jul 2011 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 ----------------------------------------------------------------- --...

T-SQL

Default keyword in SQL Server

12 Jun 2011 by Mel Padden

Default keyword in SQL Server

T-SQL

SQL-Server

Parameter

T-sql over clause to aggregating without groupby

2 May 2011 by pankajupadhyay29

A nice way to get aggregated value without group by

INSERT script from Microsoft SQL table data

5 Jan 2011 by GuruprasadV

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

T-SQL

CASE/WHEN return type

7 Dec 2010 by Pranay Rana

CASE/WHEN return type

T-SQL

SQL-Server

CASE/WHEN return type

24 Nov 2010 by Morten Nilsen

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...

T-SQL

SQL-Server

SQL Deployment Tool for Multiple Databases

13 Nov 2010 by Srinivas-Miriyala

Executes SQL scripts in multiple databases at once.