If there are no foreign keys on the table, simply TRUNCATE TABLE [YourTableName]

set nocount on

select cmd.Contents + char(13) + char(10) + 'go' as "--commands"

from (select 1 AS Seq, '' as "name", 'set nocount on' as Contents union all

select 2,...

Why do you use KiloBits for your labels (Kb), when you are calculating KiloBytes (KB)? Capitalization matters, since it changes the meaning.

What about SYSTEM_USER or HOST_NAME() ?

I'm not certain about 2005 but, in 2000, what matters is the ANSI_PADDING setting in effect on a connection when the column was created, not the current setting.  Here's an...

Darren,

You say "prefix", but show an example using "postfix."

Which is correct?

Each answer is "correct".

An example:

For 10 entries, each 10.10,

your SUM(ROUND(x, 0)) gives 100 as an answer

while ROUND(SUM(x), 0) gives 101 as an answer.

Another "Kit" possibility?

I've long wanted to "over-power" an Opel GT, so that it ran like a 'Vette,

which it somewhat resembles.

Another "Kit" possibility?

I've long wanted to "over-power" an Opel GT, so that it ran like a 'Vette,

which it somewhat resembles.

Note:  Text can be split across rows in syscomments.

Here is a Stored Procedure from one of the first issues of SQL Server Professional, I think.

Provided "as is":

/* sp_grep   v1.0 03/16/1995,...

A Clint Eastwood line, from "The Outlaw Jose Wales"

"Dying ain't much of a livin', son."

Another "Babylon 5" quote, from Security Chief Michael Garibaldi:

"What kind of Head of Security would I be if I let people like me tell me things I didn't need to know? ...

Keep telling yourself that.

It is NOT a limitation of the SELECT statement.

It is a limitation of the nvarchar datatype.

Using date-related functions is generally much faster than conversion to string.

DECLARE @d datetime

SET @d = GETDATE()

SELECT "current" = @d,

  "hours" = DATEADD(hh, DATEDIFF(hh, 0, @d), 0),

  "minutes" = DATEADD(mi, DATEDIFF(mi, 0, @d), 0)