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
155 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
310 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
189 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
197 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
191 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,639 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
171 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
223 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
201 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
943 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Adding new column with DEFAULT II
Comments posted to this topic are about the item Adding new column with DEFAULT...
Advanced Deployment Scenarios: Stairway to Reliable Database Deployments Level 7
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
You Need a DBA Pipeline
Comments posted to this topic are about the item You Need a DBA Pipeline
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers