You want to delete all records with a...

This code works:

declare @tmp numeric(38,4)
set @tmp = 9999999999 * 11
select...

Update multiple rows (in a set) using a single SP

Here is another variation of processing multiple records with a single procedure call but allowing for set processing.The helper functions make use of the sequencetable pattern. These helper functions can be used to parse strings into records, so one gets a list, or simply return the nth field.There are two functions that will parse into […]

What will the follwoing SQL statement return IN...

What does the following code do?

Declare @Year_Begin as...

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

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