Viewing 4 posts - 76 through 79 (of 79 total)
update tblOld
set obsolete = 1
where c1+c2 IN
...
February 10, 2009 at 1:37 pm
No its not. I think its a new feature in SQL 2008
February 10, 2009 at 1:24 pm
When MS SQL Server performs an operation on INT values, it returns an INT value. This means the division of two INT values will always return an INT.
The solution is...
January 26, 2009 at 9:05 pm
Another difference between ISNULL and COALESCE is IS NULL converts the data type where as COALESCE doesnt.
Example
DECLARE@X VARCHAR(10),
@Y VARCHAR(5)
SET @X = '123456789'
SELECT ISNULL(@Y,@X) will result 12345
SELECT COALESCE(@Y,@X) will result...
January 19, 2009 at 8:48 am
Viewing 4 posts - 76 through 79 (of 79 total)