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
144 reads
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
144 reads
INNER JOIN (SIMPLE JOIN): This returns all rows for which there is at least one match in BOTH tables. This is...
2016-09-26
253 reads
UNION merges the contents of two structurally-compatible tables into a single combined table. This return unique records from all the...
2016-09-26
176 reads
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
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
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,295 reads
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
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
209 reads
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
189 reads
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
894 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
In Azure SQL DB, i want to merge records from the staging table to...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers