Given this question on reddit, I cleaned up the query to point out where the issue was in the query. I use comma first and WHERE 1=1 to make modifying queries easier, so my queries generally end up like this: SELECT C.CompanyName ,O.ShippedDate ,OD.UnitPrice ,P.ProductName FROM...

I've come across the following t-sql: SELECT {d'9999-12-31'} Which returns 9999-12-31 00:00:00.000. This seems to be converting the type of the string literal to a DATETIME. I can't find any documentation on this syntax and I'm wondering if there are any variations, for example if I have a l...

As of writing this, there is no way to insert multiple rows into just an IDENTITY column using an INSERT statement. The DEFAULT VALUES placeholder stands for just one row. And the INSERT ... SELECT syntax has no extension to support the same functionality as the DEFAULT VALUES clause. Instead, y...

To insert a single row INSERT INTO RR DEFAULT VALUES; It is possible to insert multiple rows of default values by (ab)using MERGE MERGE INTO RR USING (SELECT TOP 1000 * FROM master..spt_values) T ON 1 = 0 WHEN NOT MATCHED THEN INSERT DEFAULT VALUES;