Didn't you leave out a few numbers?

declare @date datetime

set @date = getdate()

select

convert(varchar(35),@date,a.Code) AS FormattedDate,

Code = convert(varchar(3),a.Code),

convert(varchar(40),'select convert(varchar(35),@date,'+convert(varchar(20),a.Code)+')') as [SQL]

from

(

select Code = 0 union all

select Code = 1 union all

select Code...

This will do what you want:

declare @a nvarchar(max)

select

@a = isnull(@a+N' union all ',N'')+

'

select [Database] = convert(sysname,'''+a.name+

'''), [Table] = a.name collate SQL_Latin1_General_CP1_CI_AS from '+

quotename(a.name)+'.sys.tables...

Bob Hovious (4/7/2009)

---

I had a job interview once where I was asked if I had ever thrown large manuals at people. I thought it was a joke question...

Any backup strategy that does not include getting your database backups to tape is incomplete and a disaster waiting to happen.

It doesn't have to be database corruption. It could...

I...

That is an extermely bad idea. If your database becomes corrupt, you will have nothing to...

Yes, you will need to restore the transaction log backups created after your last full backup up until the point of time you want to recover to.

It is no different...

This is a better way to code date range queries:

WHERE

-- Greater than or equal to 00:00:00.000 yesterday

dtStartTimeStamp >= '2009-04-06 00:00:00.000' AND

-- Before 00:00:00.000 today

dtStartTimeStamp < '2009-04-07 00:00:00.000'

--Using getdate() to...

Sudiendra (4/7/2009)

---

T-Log backup - Every 15 Minutes and Retention Period - 2 Days

Differential Backup - Every day and Retention Period - 1 day (Until the next Diff backup)

Full Backup -...

GilaMonster (4/7/2009)

Similar thing here. In my country, woman and IT don't usually go in the same sentence. The number of times I've been 'mistaken' for the project manager, the token...

That wasn't harsh.

My first reply on this thread below wasn't harsh...

I have always found the DATEADD/DATEDIFF method to be the fastest when I tested it.

I would avoid using FLOOR method for the simple reason that it is an unsupported method...

You cannot reset the timestamp generation.

What you are describing is bug that needs to be fixed. There was never any reason to assume that a timestamp column can be...

YSLGuru (4/6/2009)

---

Jason Miller (4/6/2009)

---

And the follow-up where,

select Col1, Col2, count(*)

from dbo.MyTable

GROUP BY Col1, Col2;

select Col1, Col2, count(*)

from dbo.MyTable

GROUP BY Col2, Col1;

Are...

Yes, you can place the files anywhere you want.