Viewing 15 posts - 1 through 15 (of 819 total)
If I want to check that ONLY the CustomerContactFirstName and CustomerContactLastName are update, then the right command is
IF COLUMNS_UPDATED ()= 0x0C0000
If I want to check that the CustomerContactFirstName and CustomerContactLastName...
August 27, 2025 at 6:48 am
The answer is correct, but the explanation is wrong. The error in the second statement occurs because, after the keyword DEFAULT, you must specify an expression, not the name of...
June 20, 2025 at 6:55 am
The truly correct answer is "Each full beer name and the first 20 characters of the beer description".
If "beerdescription" is NVARCHAR(MAX), than the "select" returns only 10 characters.
April 9, 2025 at 7:09 am
uhm, what about "Temporal tables"?
"Temporal tables" do not need to be backed up and restored, you can see values in the "past" and restore them with a query.
"SQL Server 2016...
March 24, 2025 at 8:07 am
UPDATE myTable WITH(NOLOCK) is not permitted by SQL SERVER, so, it's impossible to try.
In any case, I prefer the option "SET TRANSACTION ISOLATION LEVEL SNAPSHOT", so, I can read committed...
December 9, 2024 at 11:23 am
The correct answer is "ServerProperty with the EngineEdition". It returns 6 for "Azure Synapse Analytics".
September 6, 2024 at 6:55 am
Not Exists vs Not In:
SELECT *
FROM dbo.Candidates AS c
WHERE
NOT exists
( SELECT PersonName FROM dbo.Person WHERE Person.PersonName = c.PersonName);
July 29, 2024 at 7:41 am
The correct answer is "Customers_b only", because the definition of primary key is that all column should be "NOT NULLABLE".
In this way you can JOIN tables by the PK without...
July 5, 2024 at 7:51 am
From BOL: "If a marked transaction spans multiple databases on the same database server or on different servers, the marks must be recorded in the logs of all the affected...
June 7, 2024 at 7:57 am
Instead of views, I use a lot TVF and CTE, the limits are the same as for views.
Here an example:
create table a (i int)
GO
create function myfn_a(@i int)
returns...
April 22, 2024 at 11:01 am
From BOL:
REMOTE cannot be used when one of the values being compared in the join predicate is cast to a different collation using the COLLATE clause.
The query fails only if...
April 8, 2024 at 10:39 am
The default values for parameters are not stored anywhere in the DMVs.
This statement is incorrect
SELECT ProcName = pr.name
, ParamName = p.name
...
December 20, 2023 at 8:18 am
Typo in answers: sys.modules is wrong, as it stated in the explanation: sys.sql_modules.
December 20, 2023 at 8:09 am
Viewing 15 posts - 1 through 15 (of 819 total)