Script Generator

It is a modified version of original script I found on net. This script creates conditional Update statements too.

What does the DEALLOCATE statement do in SQL...

Speak Like a T-SQL Developer

In this video by Kathi Kellenberger, she starts beginners interested in T-SQL programming the teminology and some of the basiics of T-SQL. She also covers the what the various editions of SQL Server mean and the tools that you will use.

What does @@textsize return?

SQL Server 2005 Common Table Expressions

A CTE is a "temporary result set" that exists only within the scope of a single SQL statement. It allows access to functionality within that single SQL statement that was previously only available through use of functions, temp tables, cursors, and so on.

What would happen when you execute the code...

What does @@MAX_PRECISION return?

Script to get total rows and space used

Script to Get Total Rows, space used and reserved (KB) of all tables

Change to readable date format

Trigger to insert date into table in the form of01/01/00 12:00:00instead of SQL standard date format2000-01-01 12:00:00.000This allows easily comparing to or updating based onOracle date formats or a readable format for the web.triggername - name of the triggerTABLENAME - name of the table that trigger is created onCOLUMNNAME - name of column in TABLENAME […]

Encrypt DTSRUN command

Encrypting a DTSRUN command in T-SQL