What will be the result of the query below? Explain your answer?
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
145 reads
TSQL Circle Live
Different types of ANSI standard joins
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
260 reads
What does UNION do or what result set UNION return ? What is the difference between UNION and UNION ALL?
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
177 reads
SPACE
USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...
2016-09-04
187 reads
STUFF
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
168 reads
Common uses of stored Procedure sp_MSforeachtable
We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.
sp_MSforeachtable can be used to loop through all...
2016-05-09
11,362 reads
Get each table space and their rows count
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
163 reads
Generate list of all Month name
DECLARE @year INT
SET @year = 2016
;WITH months AS(
SELECT 1 AS Mnth, DATENAME(MONTH, CAST(@year*100+1 AS VARCHAR) + '01') AS monthname
UNION ALL
...
2016-04-11
211 reads
SQL Create Table
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
194 reads
SQL Basics for Beginner
SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...
2016-02-08
895 reads
Blogs
PASS Data Community Summit LinkedIn Contest
By Brian Kelley
If you're not having success in convincing your organization to send you to this...
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
By Rohit Garg
When deploying SQL Server in enterprise environments, choosing the right service account model is...
Andreas Wolter on Evading Data Access Auditing
By Brian Kelley
There are always bad actors who will seek to get access to and, likely,...
Forums
Determining the Updated Columns
Comments posted to this topic are about the item Determining the Updated Columns
Carrots and Sticks
Comments posted to this topic are about the item Carrots and Sticks
Replace with like join
I am trying to create and Update query based on a like join. Is...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers