You might be right. Here is what I pulled from the HELP from SSMS for "Datetime data type >> about datetime data type":

" ... Values with the datetime data...

Are datetime datatype stored as floats or is more like date is one integer (the number of days from 1/1/1900) and the time another integer (the number of 1/300th second...

'' will auto convert to numeric 0 which will autoconvert to the "zero date" which is 1/1/1900. I am pretty sure that it was this way back in the...

Another potential idea is something like:

declare @test-2 table(tString varchar(12))

insert into @test-2

select null union all

select '' union all

select '$1,234' union all

select '1111D1' union all

select '11E2' union...

I think you are right; with Oracle I got:

select *

from

( select 0 as field1 from dual union all

select 1 as field2 from dual

)

where field1 = '';

/* -------- Output...

That is more-or-less the expected behavior. Keep in mind that '' can be auto converted to zero. For example:

declare @test-2 table(field1 int)

insert into @test-2...

Just make sure you have an index that has customer Name first and insert using a WHERE NOT EXISTS clause on customer name -- should be very fast.

Edit:

Something else you...

7000 is not a large number; it seems to me that it might be more appropriate to have your select list just fetch the distinct records rather than take the...

A float datatype is not a precise datatype; give a look at this datatype in books online. If precise decimal positions are needed you might want to consider either...

Assuming that you might have more than one "PageFlow ID" it might be translated into relational division with something such as:

select

sessionId,

id

from

( select

sessionId,

...

The default setting for QUOTED_IDENTIFIER is to ON. This provides the ability to enclose column and table identifiers in double quote marks to define an identifier. The biggest...

I have seldom used application roles because (1) they have to be activated on an ad-hoc basis and therefore cannot be set from stored procedures and (2) automatically setting the...

After re-reading the exchange I think my question was wrong because I was focusing on the wrong part of the question. The orignal question, "... Is it possible for...

OK, Jeff, but that was not what I was asking.

Jeff:

What are the circumstances for that? When I run the following query it get the commented results:

use tempdb

go

select name as before from sysobjects where type = 'U'

exec ( 'create...