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
186 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
186 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
173 reads
select case when null = null then 'True' else 'False' end as ResultSet;
2016-09-26
138 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
185 reads
Use case when we are working on TSQL or Query ,some time we came such a situation when we need...
2016-09-04
166 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
10,397 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
194 reads
Sometime we need to know how much table space are used to store the data and also wish to know...
2016-04-11
150 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
778 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
181 reads
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Hi All, Hi All, I want to convert columns result into rows with comma....
Does multi subnet failover with standard edition of sqlserver supports DB Mirror or AG...
Any one did Table partitioning in Prod, please list steps here. we have a...