Viewing 15 posts - 1 through 15 (of 35 total)
We are not so bad for that here, but there have been changes that, like you, I don't feel that it's me. Rather they leave everyone doing what they did...
April 14, 2020 at 11:01 am
Depending on the table size and the amount of data changed/deleted/updated I use output inserted, output deleted into a table in another database. When I have reviewed the changes or...
October 29, 2019 at 12:04 pm
Confused, dates do not match but the print answer is wrong as well. Looking forward to the explanation.
September 27, 2019 at 8:57 am
I think you have just given away the answer to the next question 😉
September 16, 2019 at 10:05 am
Agree, but with the provision that you can view the changes or edits. In our system, you are able to mark data as incorrect but others can still view that...
August 21, 2019 at 8:14 am
I could see this becoming a QOTD 🙂
July 20, 2017 at 10:13 am
Currently in the process of re-processing folders where there was an error reported. As there are thousands of them, created some code to help me write the batch files for moving...
May 11, 2017 at 7:01 am
I work with creation of new SQL code as well as maintenance, and due to the different servers and versions I use SSMS almost exclusively.
but also use Enterprise Manager as...
March 27, 2015 at 3:54 am
Thanks for the quick explanation, took to read the full explanation of COALESCE and ISNULL to get a better understanding again.
Keep on learning...
February 12, 2015 at 4:18 am
Don't worry, I will always test before I implement. This was more a 'gut feeling' and wanted to make sure that other users where not going to take this a...
February 12, 2015 at 3:45 am
IF NOT EXISTS
where a =...
February 10, 2015 at 9:07 am
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Line 4
Must declare the...
December 19, 2014 at 3:36 am
Nice and easy...
December 19, 2014 at 2:40 am
I have normally no problem here for getting day's off, or for taking holiday at all. When you have young kids it's for us cheaper to take the time off...
November 20, 2014 at 4:07 am
I am always surprised that when the question and answers hint that the database is not case sensitive there is no mention about this. All our databases are case sensitive...
November 13, 2014 at 3:38 am