Viewing 15 posts - 17,866 through 17,880 (of 18,926 total)
Maybe there's another way, but I think the safest way would be to recheck every statement to make sure it returns the correct result (not just this one as something...
May 9, 2005 at 10:07 am
I'm not sure how to change the db settings so I'll let someone else answer this one.
this solution however shows you how to change the setting on the connection
SET ANSI_NULLS...
May 9, 2005 at 10:03 am
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...
May 9, 2005 at 9:52 am
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...
May 9, 2005 at 9:20 am
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???
May 9, 2005 at 7:36 am
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...
May 6, 2005 at 1:21 pm
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'
May 6, 2005 at 1:08 pm
Select * from INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'Departement'
May 6, 2005 at 12:32 pm
Select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where TABLE_NAME = 'tablename' AND CONSTRAINT_TYPE = 'UNIQUE'
May 6, 2005 at 12:30 pm
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.
May 5, 2005 at 12:13 pm
Update Inventory
set DateColumn = CASE WHEN ISDATE(DateStringColumn) = 1 THEN convert(datetime, DateStringColumn, 101) ELSE NULL END
May 5, 2005 at 10:49 am
That's gonna be an interesting answer. Let me get some popcorn and coke before you answer that one
.
May 5, 2005 at 10:13 am
Ya but nobody loves me... does that mean something?
May 5, 2005 at 10:13 am
O'll be sure to get my hands on one of these books. Thanx Nick.
May 5, 2005 at 10:10 am
Viewing 15 posts - 17,866 through 17,880 (of 18,926 total)