Function to Expand Tab Characters

A function to replace tab characters with the correct number of spaces to align the text as originally intended.

Collation Error 468

Most DBAs don't ever deal with multiple languages or different collation and sort order settings in SQL Server, but it can be a handy piece of information to have. Steve Jones brings us a quick look at a problem in comparing data across databases.

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures

What does this return?

Clear all the data from tables

This script will delete all rows from the database, except system tables.

Get dependant Objects

Get Dependant Objects by passing table name or stored procedure name.

Get Splitted Value From the String Format Specifie

Functuion Which returns splitted values from the string format specified in example

Handling NULL values in SQL Server 2005

In the simplest terms, a NULL value represents an unknown value. It's unknown in the sense that the value is: missing from the system, may not be applicable in the current situation, or might be added later. NULL values are different than any other value and are sometimes hard to compare and handle.

What does this return?

select ceiling( 53.5)

create log tables and trigger modyfied

i was trying to use the script 'create log tables and trigger' by well0549 it was very helpfull but at some tables it just didnt work ..later i find out that these tables have an identity columns but they were tinyint or small int .. i didnt do much but i did add less than […]