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, 7 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 ... 🙂

Today's Qotd leads to a secondary question, "What's new in SQL Server 2019?". There are fantastic things there will be enough to study. Thanks for this interesting question, Steve.
Happy...

Pretty useful Christmas present, thanks for him Steve.🙂
Happy merry Christmas!