Thanks Thomas for a funny but interesting question, and thanks

Oddvar for the reminder sp_describe_first_result_set.

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

then the expression after...

Thanks for an interesting question. I did not find in the docs a link to DROP EXTERNAL TABLE for Azure SQL Database. This page DROP EXTERNAL...

• This reply was modified 6 years, 8 months ago by George Vobr.
• This reply was modified 6 years, 8 months ago by George Vobr.
• This reply was modified 6 years, 8 months ago by George Vobr.

The syntax description in the reference states that header is a logical value indicating whether the file contains the names of the variables as its first line. If missing, the...

USE TestDB;
GO

--Weird question, pleas try this in Results to Text mode:

CREATE TABLE dbo.my_table (my_field INT);
INSERT dbo.my_table VALUES (1),(2),(3),(30),(40),(50);
GO
-- Syntax error in CASE clause!
UPDATE dbo.my_table SET my_field =...

• This reply was modified 6 years, 8 months ago by George Vobr.

Datetimeoffset defines a date that is combined with a time of a day that has time zone awareness and is based on a 24-hour clock.

If you would like to represent...

Bravo Thom, it's a great question with an excellent explanation!

Thanks for this interesting T-SQL question Steve.

Thanks for this interesting question Steve. I had to check for a while whether sysdiagrams table is a system table or not.😉

Great question about a little known but not completely safe feature of SQL Server – numbered stored procedures.
Notice the use of semi-colon here. The semi-colon is not used...

Yes, IMHO, the answer "SQL Server 2017+" is not quite right.

Yes, they did at least something, but I want to start the new year in an optimistic mood ... 🙂