Local temp table and Global temp table
What is Local temp table and Global temp table Temp tables are like a physical table but it’s always creating in tempdb database and its name start with hash (#), It’s automatically drop when...
Tagged: sql server development
Common table Expression (CTE)
What is Common table Expression Common table expression (CTE) is a temporary result set and store the result set like normal view that can be use within a SELECT, INSERT, UPDATE, or DELETE statement....
Table Type and Table Valued Parameters
What is User-Defined Table Types User-Defined Table Types (UDTTs) is a kind of user defined data type its can be pass as a parameter in procedure where we need to pass multiple rows and...
Correlated and Subqueries
What is SQL Query SQL is a Standard Query Language for storing, manipulating and retrieving data in databases. SQL is a programming language(Query programing language) like PHP, Java, .net etc language use for application...
Derived Tables – Sql server
Derived Tables are similar to table variables it’s exist in memory only many deferent is table variable need to declare and derived table always create within a select statements, its also called to Subsquery....
Merge Statement
MERGE statement generally used in warehouse ETL process where we need to perform multiple operations like insert, update and delete data in target table based source table. MERGE statement joins target to source by...
Auto Increment Functions
we have mainly 4 ways for get last identity (auto increment) values after an INSERT, SELECT INTO, or bulk copy operation. Like @@identity, scope_identity, ident_current and identity but there are a few differences between...
Recent Comments