This is another example of Microsoft versus ANSI/ISO. When we set up the DECIMAL and NUMERIC data types, we were thinking of COBOL style picture data and BCD data. The...

>> I have two tables= <<

Really? Then where's the DDL for these two tables? Why do you think an identifier can be numeric? What math are you doing on them,...

>> IDENTITY() is a piece of automation that solves a set of tricky problems for you. <<

Actually, IDENTITY creates problems rather than solve them. Essentially, you've decided to throw away...

>> Also, considering that VALUES didn't actually come out until 2008, your lecture about getting rid of the old syntax "decades" ago is full of hooie.<<

Looking over my old ANSI...

Please learn the difference between a row and a record. It's very important for RDBMS.

I also wish you would learn to read the posting netiquette for this forum. Where is...

Many years ago, I was asked by a graph database company to solve the "Kevin Bacon problem" in SQ to compare to their products solution. If you don't know this...

https://en.wikipedia.org/wiki/ISO/IEC_5218

Those of us who follow ISO standards use 0=unknown, 1= male, 2= female, 9= lawful person (churches, corporations, etc.) And make the column not null.

First of all, if a table doesn't have a key. It's not really a table. Is there any kind of documentation that can give you a hint as to what...

We need to correct your attempt at DDL. By definition, a table must have a key, but this is impossible with your DDL because both columns are NULL You have...

Never, never use that highly proprietary and totally nonrelational SQL_variant data type. We designed SQL to be a strongly typed language. The relational model depends on strong data typing. It's...

>> I'm building a web app to maintain some data, which is mostly flat but will benefit from having some static look-up tables. Typically these look-up tables with have at...

Please don't ask dumb questions. Do you really believe that the payroll for the United States government query should execute anywhere near the query for your knitting club? A query...

This should not be a problem at the database tier in your tiered architecture. Do this in the input, before it even gets near the tables. You'll find ETL tools...

This is a CASE expression, not a statement. This is important because it is why this works and has an implied "ELSE NULL" clause.