SQL Server Performance Forum – Threads Archive
Explicit conversionin sql 2000 i could do this: SELECT * FROM MyTable WHERE Fld1 > 8 AND Fld2 = ‘test’ (where Fld1 is a varchar) and it returns no error
wen i ran the same query on SQL2005 five it gives me an error, because there are some values in Fld2 which are not numbers. Is this somewhat a new rule in sql2005. if yes, could someone give me a link where it explains such. thanks!
Please move to Yukon Forum.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.