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...
Monthly Archive: July 2019
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...
What is DBMS
DBMS(database Management System) is System for manage data in database system. Types of database Management System: Mainly 4 types of database management system(DBMS) available but 1 more NoSQL can considered in DBMS 1.Hierarchical DBMS...
Recent Comments