Viewing 15 posts - 1 through 15 (of 37 total)
Only recently noticed that my newsletter was missing, due to all other things I have coming in. Missed it in hind sight, but 3 a week is a nice compromise.
April 28, 2021 at 8:47 am
There are 2 answers here that are correct, it just depends on what you choose. The answer shown as correct is rightly so, but the answer that states that the...
January 19, 2021 at 12:00 pm
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