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 6 years, 4 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.

You also can create synonym without an existing object.

In your example you mismatched the synonym StagingSongs with SongStaging

CREATE SYNONYM SongStaging FOR #songs
GO
CREATE PROCEDURE dbo.LoadSongs
AS
INSERT Songs
(
songid,
title,
releasedate,
genre
)
SELECT songid,
title,
releasedate,
genre
FROM dbo.StagingSongs
WHERE...

The second dot is a "virtual AS".

Absolutely NO, but if you like to think so OK.

This clearly shows that if the expression before the dot is data type numeric,

then the expression after the dot is taken as a column name.

The dot is part of constant...