I'll give this to you but keep in mind that you could break the whole app by changing this setting.. but since it seems to be already the case it...

select * from qrbanca where codabi = '03069'

in this case will return all records (nulls or not)

I might add that citta like '%' filters absolutely nothing (besides nulls in this...

What's the avg run time of the queries?

What are the most ran queries?

How many queries/minute do you run?

Do you have auto-clause or auto-shrink set to on on any production database???

Declare @Input as varchar(25)

set @Input = null

Select case when @Input is null then 'none' else @Input end, isnull(@Input, 'none')

set @Input = '8'

Select case when @Input is null then 'none' else...

This will give you the columns too... but you'll have to filter out the constraint types using the first query I gave you..

Select * from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE WHERE TABLE_NAME = 'tname'

Select * from INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'Departement'

Select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME = 'tablename' AND CONSTRAINT_TYPE = 'UNIQUE'

Yes it's the same query... and they'll all most likely end up as clustered index scan (or bookmark lookup).... unless field4 is the primary key of the table.

Update Inventory

set DateColumn = CASE WHEN ISDATE(DateStringColumn) = 1 THEN convert(datetime, DateStringColumn, 101) ELSE NULL END

That's gonna be an interesting answer. Let me get some popcorn and coke before you answer that one .

Ya but nobody loves me... does that mean something?

O'll be sure to get my hands on one of these books. Thanx Nick.

As Scott said, a cursor is just that, too.

You'd load them back into sqlserver....

Seriously why do you want to take those records out of the database?

How many records r u talking about?

Select *

FROM tablename

WHERE datefield > '1/1/2005'

This is assuming you're having a syntaxe error..

What results did you get... what did you want to have?