CTEs are used to make the query easier. Whenever there are too many joins are being…
Author: Hari Shankar
What is the use of “DISTINCT” in Sql Server?
“DISTINCT” keyword is used to remove the duplicate values in a given column. Example SELECT DISTINCT…
How to use single , double and triple equalto (=,==,===)?
= is used to assign value from one value to another. == (Equality) is used to…
what is order by vs group by in sql server ?
Both order by and group by are used to organize data according to user needs. ORDER…
What is microsoft .net assembly?
Microsoft .net assembly ->Microsoft .net assembly is a logical unit of code. ->It contains code which…
LOCAL AND GLOBAL TEMP TABLE
WHAT IS DIFFERENCE BETWEEN LOCAL AND GLOBAL TEMP TABLE? LOCAL TEMP TABLE Local temp table visible…
WHAT IS A TRIGGER
WHAT IS A TRIGGER Trigger is used for firing a any action when SQL operations like…