GO

TIME Gentlemen please! The SQL Server temporal datatypes

If you are still using the old Sybase DateTime datatype, it is a good idea to move your code to the more standard datatypes that were introduced in SQL Server 2008. Joe Celko explains why, and walks through some of the history of the TSQL way of storing and manipulating dates and times.

Parameterization Settings

STUFF Function

Identity Crisis: Attack of the Clone

Identity Reseed

Check your Digits

The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.

Adding Column to a SQL Server Table

This article examines the difference between adding a nullable column to a table or a column with a default value.

Type

OUTPUT & NEWID()