Glad we could help.

The BOL article on sysdatabases.

I just checedk BOL again and according to it, the ISO 8601 format is unambiguous in SQL Server. Thing is, apparently I have been using a shortened colloquial form...

I'm with you Gus. The ISO 8601 standard was godsend when it came out. I really would not want to have to go back to constructing dates by...

Yeah, but "YDM" is not the date standard for any nation. That's why ISO choose it. And what is the alternative way to do this that is not...

OK, I checked and yes, "YYYY-MM-DD" is the ISO 8601 standard for "unambiguous numerical text date format". (see here: http://www.uic.edu/depts/accc/software/isodates/index.html).

Also, as to the representation of date constants, here is what...

Chris Morris (1/8/2009)

---

Why would you want to make a statement like this with ambiguous dates? If I run your code here in the...

A much better way is to use the OUTPUT clause,like this:

--====== Make our test table to insert to

Create Table InsertIDTst(

ID int identity primary key

, ColName nvarchar(255)

, object_id int);

GO

--====== Make a...

Figured it out:

Select DATEADD(dd,DATEDIFF(dd,0, getdate()), 0)

The "DATEDIFF" method is supposed to be the fastest, but I can never remember it off the top of my head.

There are several ways to strip the time out, here is one:

select cast(floor(cast(getdate() as Float)) as datetime)

RBarryYoung (1/8/2009)

---

Erin: If you take this route, based on the App Name attached to the connection, you should be aware that this is just a barrier, it's not truly...

Erin: If you take this route, based on the App Name attached to the connection, you should be aware that this is just a barrier, it's not truly secure...

The only thing that I can think of here is that maybe your sProc is doing a SELECT into a table with a different schema/owner, but when you execute your...

For testing you generally follow one of the following approaches in order to normalize this otherwise inconsistent behavior:

1) empty the caches before each individual test, or

2) do several iterations of...