Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
CTE.sql		CTE.sql
Case Statement.sql		Case Statement.sql
Constraint and Relationship between Tables.sql		Constraint and Relationship between Tables.sql
Creating Database and Tables.sql		Creating Database and Tables.sql
Dense_Rank and Derived table ,Rollup ,Cube, Grouping Sets.sql		Dense_Rank and Derived table ,Rollup ,Cube, Grouping Sets.sql
General Query and Joins.sql		General Query and Joins.sql
Insert Query.sql		Insert Query.sql
Merge.sql		Merge.sql
README.md		README.md
Self Join.sql		Self Join.sql
Set Operators.sql		Set Operators.sql
Store Procedure and Exception Handling.sql		Store Procedure and Exception Handling.sql
Subquery.sql		Subquery.sql
Trigger.sql		Trigger.sql
Types Of Locks,Isolation Level and Index.sql		Types Of Locks,Isolation Level and Index.sql
User Defined Functions.sql		User Defined Functions.sql
Views.sql		Views.sql

Repository files navigation

MS-SQL-project-T-SQL-

About

Created Employee_Record Database with Different Tables, adding a constraint to the tables, like Primary, Foreign key, Unique key, Check key, etc, stored procedure with Exception Handling, User Defined Functions, Triggers, Subquery, advanced functions like Rollup, Cube, Grouping Sets, etc., CTE, Derived Table, Cursor, Joins, Merge, Indexes, Types…

Readme