Viewing 15 posts - 1 through 15 (of 1,205 total)
From the potential program or method, I am hoping to find via this topic. I confirmed the query by using excel, so all I need is a program that can...
July 28, 2022 at 7:39 am
The obvious question is from where are you running this query?
July 27, 2022 at 9:33 pm
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.
July 12, 2022 at 7:48 pm
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...
July 12, 2022 at 5:21 pm
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,...
July 8, 2022 at 9:14 pm
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....
June 24, 2022 at 8:41 pm
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...
June 21, 2022 at 12:20 pm
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...
June 1, 2022 at 8:09 pm
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...
May 27, 2022 at 7:33 pm
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...
May 19, 2022 at 6:46 pm
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...
May 10, 2022 at 2:10 pm
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...
May 4, 2022 at 10:39 am
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...
April 21, 2022 at 6:39 am
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...
April 7, 2022 at 6:31 pm
Have a look at https://www.sommarskog.se/query-plan-mysteries.html#dmvgettingplans where I have a query for this.
April 6, 2022 at 6:06 pm