Sorry for [semi]colon 🙂

It's all right for error, because GO is a batch separator: @x is declared in the first batch and not in the second. It's the same as...

A semicolumn is missing after the two exclamation mark.

Here's from BOL:

Supported SQLCMD Syntax

The Database Engine Query Editor supports the following SQLCMD script keywords:

[!!:]GO[count]

Interesting! Well done!

By that reasoning you should also include THROW, as well as modifying data in tables (particularly temp tables created by the caller).

Personally,...

By that reasoning you should also include THROW, as well as modifying data in tables (particularly temp tables created by the caller).

Personally, I would...

5

Also with PRINT and RAISERROR

• This reply was modified 4 years, 9 months ago by  Carlo Romagnano.

Well done!

That's correct: "an empty result set preserves the existing value of the variable", NO result set, NO assignment. In the case of SET or SELECT with a subquery (as shown...

The interesting thing is that rounding to 1 decimal the result is 30.

DECLARE @tmp1 FLOAT = 0.289;
SELECT
CONVERT(INT, ROUND(@tmp1, 1) * 100.0)

I prefer "implicit transaction", they are more safe than "begin tran" in case you use "GO" in the script.

SET IMPLICIT_TRANSACTIONS ON
;with a
as
(
SELECT * FROM dbo.account WHERE account_code='4c'
)update...

Inside dynamic sql I prefer to use the /**/ comment to avoid bug in concatenation.

Well Done.

GO

CREATE procedure spt

as

SELECT C.CustomerID

FROM

(

SELECT

sh.CustomerID,

OrderDate = MAX(sh.OrderDate)

FROM dbo.SalesHeader AS sh

GROUP BY sh.CustomerID

) AS C

INNER JOIN C AS c2

ON C.CustomerID = c2.CustomerID;

GO

This is a demonstration that the error is at execution time...

Here it stats https://docs.microsoft.com/it-it/sql/t-sql/statements/alter-database-transact-sql?view=sql-server-ver15, too.

It's impossibile because of division by 0.000 (with 3 decimal).

I got it wrong, I thought you want the name of the month %B.