least/greatest are not available in SQL 2019, but they will appear in SQL 2022. It is correct that they are avialable i Azure SQL Databsae and Azure Managed Instance.

Your exact requirement is not clear to me. (Tip: include CREATE TABLE + INSERT with sample data and the expected result). But here is the general pattern for this type...

The WHERE clause is not used instead of an ON clause. The WHERE clause is always, logically, that is, a filter of the result of the FROM-JOIN operations.

As Johan says,...

An important principle in SQL is "All at once". One consequence of this is that all expressions in the SELECT list are defined at once, and not one by one....

Your post is quite open-ended and there are many sub-questions. At this point, I will mainly address this point:

Is it possible to derive a column based off another derived column...

There are two ways you can set up a linked server:

The default is self-mapping. That is, user A logs in on server S and runs a query against linked server...

First of all, what OS do you have? Not very many OSs supports both SQL 2008 R2 and SQL 2017, and if it supports SQL 2008 R2, the OS is...

Is this on your private machine or is this in a corporate environment?

In C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log there should be one folder per install attempt. The files of most...

Maybe. With the information you have shared there is nothing that makes me scream out NO! However, there is very little you have told us, so there may be something...

The full-fledged Express Edition runs as a service. But, localdb runs in user-space so it could serve for a single-user application. Although, I mainly think of localdb as an aide...

Normally you use the DELETE statement. You don't say which SQL product you are using and I guess the TRUNCATE statement works differently in different products. But I would expect...

If the batch is a stored procedure called through RPC, DBCC INPUTBUFFER will only give you database id and object id for the procedure. To my knowing there is no...

Have a look at https://www.sommarskog.se/query-plan-mysteries.html#dmvgettingplans where I have a query for this.

• This reply was modified 4 years, 1 months ago by Erland Sommarskog.

Why not arrange so that they get SSMS and instructions to run your procedures? By time they can learn to write queries themselves. Obviously, you need to make sure that...

I believe there is a Data Compare option in Visual Studio if you have SSDT installed.

Else you can run queries like this:

SELECT *
FROM   dbA.dbo.tbl A
FULL...