Viewing 15 posts - 1,966 through 1,980 (of 2,645 total)
November 20, 2018 at 6:33 am
You can use IIF from SQL 2012 onwards. It does the same as CASE but with a bit less typing:IIF(Col1 IS NULL,Col2,Col3)
November 19, 2018 at 10:09 am
November 19, 2018 at 8:29 am
I think you should let the developers know the password to the development database. For production you can put the password in a Package Configuration file.
After all if the...
November 19, 2018 at 8:15 am
I've come across a stored procedure that has this code.
DECLARE @status INT =...
November 19, 2018 at 8:07 am
November 19, 2018 at 7:05 am
November 19, 2018 at 6:30 am
November 19, 2018 at 6:16 am
I have a requirement to change the date to 1900-01-01 if its an invalid date...
November 19, 2018 at 4:59 am
November 19, 2018 at 3:42 am
November 18, 2018 at 11:42 am
November 18, 2018 at 9:52 am
November 18, 2018 at 9:07 am
November 18, 2018 at 9:02 am
Viewing 15 posts - 1,966 through 1,980 (of 2,645 total)