I had to check to see what the outcome was, as I was surprised that the text would display | ABC|

The text does not get capitalized, it is | abc|

I have this code on SQL Server 2017:CREATE FUNCTION AddOne

(@i INT)

RETURNS INT

AS

BEGIN

DECLARE @result INT;

SELECT @result = @i + 1;

RETURN @result;

END;

GO

SELECT AddOne(3)

When I execute this, I get the following error: Msg...

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.

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...

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...

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...

Confused, dates do not match but the print answer is wrong as well. Looking forward to the explanation.

I think you have just given away the answer to the next question 😉

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...

I could see this becoming a QOTD 🙂

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...

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...

Thanks for the quick explanation, took to read the full explanation of COALESCE and ISNULL to get a better understanding again.

Keep on learning...

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...

dwain.c (2/6/2015)

---

Is there some reason you don't want to do this?

IF NOT EXISTS

(

select H

from table_1

where a =...