Interesting examples, even if function to be avoided.  But I am puzzled as to why the time on the last example (Universal Date Long Time) 6 hours different from the...

I made a lucky guess and I still don't know what language this is.  I expect it is R or Python but it would be nice to have that much...

I've been wondering how to find settings for years.  Learned a lot on this question along with the last article before it: @@OPTIONS, bitwise comparison, Databasepropertiesex, dbname(), Sessionproperties and even...

I don't understand why deleted only shows the first row from each group.  The join is to all rows in the group.  I changed the values on description and it...

I just guessed not even knowing what language this was about.  The QOTD in my email has no subject.

It should be noted that:
Beginning with SQL Server 2016, all algorithms other than AES_128, AES_192, and AES_256 are deprecated. To use older algorithms (not recommended) you must set...

Here is a way to generate the list of all columns in the table that are not identity.  Needs some modification for the script.  You can then use the list...

According to https://stat.ethz.ch/R-manual/R-devel/library/base/html/assignOps.html x = 42 is also valid.

Long ago my company had many passionate discussions about 'what is a database?'  The best definition I got out of it all is that a database is any place you...

I got the answer right but now know that that was wrong and the real answer is that it cannot be done.  I have a table that has two triggers...

I always right click and copy with headers.  I shows the ctl+shift+c key combination in the menu but I never do it that way.