Thanks Steve for this interesting question. I'm surprised how cute Python is, he doesn't mind square brackets in the right answer ... 🙂

Ah..., my apologies, it is obvious that in the expression '1.77 + 0. test' is the second dot also an decimal point. I had to be blind. I have overlooked...

Hi Carlo, yes you're right. The first dot in constant numeric number in the selected

expression is the decimal point. The second dot is a "virtual AS".

SELECT 1.77+0....

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 5 years, 3 months ago by  George Vobr.
• This reply was modified 5 years, 3 months ago by  George Vobr.
• This reply was modified 5 years, 3 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 5 years, 3 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.