Create table DemoTab1
( clientno integer,
dob datetime )
go
insert...

Manipulating And Using DateTime Data

Working with date and time data in SQL Server can be a bit cumersome using just T-SQL. With the separate datatypes being pulled from SQL Server 2005 for the time being, however, it is something that a DBA needs to get used to. Robert Marda brings us an instructional look at the different datetime data types and some things you should be aware of when developing with them.

Which of the following is an example of...

In SQL Server 2000, which of the below...

You have the following data and query:

Tab_A...

On SQL Server 2000, what will be the...

There is the data in the People table:

foo_id...

Cursors with SQL 2000 Part 1

This series of articles will examine the purposes, uses, and optimization of cursors in SQL 2000.

Utility proc for updating (sub) sequence columns

This is a utility proc that I use a lot for datawarehouse transformation/load processing. This is a generic proc for resequencing an integer column in sorted order within a given key combination.Note that 'key' is used here in a general context and not specific, that is there doesn't have to be any keys or indexes […]

SQL Server 2005 has a number of T-SQL...