The scope of "set language" and "set datefirst" is per session and also per procedure/function

Try this:

create procedure proc_datefirst

as

set language 'us_english'

select @@DATEFIRST

go

set language 'Italian'

exec proc_datefirst

select @@DATEFIRST

Clear and easy question!

Thanks:-)

Thanks!

Clear qotd!

😛

Thanks!

😛

A version of the query without the use of local table:

SELECT *

FROM (

VALUES ('Steve')

, ('Stephan')

, ('Stephanie')

...

The correct exceution of the query depends on ansi_warnings

set ansi_warnings off

DECLARE @i TABLE( mychar VARCHAR(10));

INSERT @i VALUES ('Steve'), ('Stephan'), ('Stephanie')

...

Unusual altering a disabled trigger, but it's good to know!

😉

Maybe, the author exchanged the CAST and the ISNULL:

The right version:

DECLARE @x CHAR(1)

SET @x = CASE

WHEN @x = 'x'...

Thanks for the question!

🙂

Fantastic!

The usual SEVEN!

Here is sp_configure with a simple optimization:

-- Use @configname and try to find the right option.

-- If there isn't just one, print appropriate diagnostics and return.

select @configcount = count(*)

...

Here is the code from sp_configure:

-- Use @configname and try to find the right option.

-- If there isn't just one, print appropriate diagnostics and return.

select @configcount = count(*)

from sys.configurations

where...

In the answer a word is missing "Distributes".

So, NTILE returns the number of the group to which the row...

Tom, re-word the question, maybe I get it right!

Unreadable!