What is Derived Tables & CTE in Sql Server and Compare with – views, tables variables, local and global temp tables

What is Derived Tables & CTE in Sql Server Compare with – views, tables variables, local and global temp tables --********************************************************* create table Department ( DeptId int primary key, Deptname varchar(23) ) create table Employee ( Id int, Name varchar(32), Salary float, Gender varchar(23), DepartmentId int  foreign key references Department(DeptId) on delete cascade ) insert...

Read More

Temporary tables in Sql Server

Temporary tables in Sql Server Temporary tables , are very similar to the permanent tables. Permanent tables get created in the database you specify, and remain in the database permanently, until you delete(drop)them.On the other hand, temporary tables get created in the TempDB and are automatically deleted, when they are no longer used. Different types of temporary tables: Local temporary tables Global temporary tables. Now we create...

Read More

Veiw and its Advantages in Sql Server and What is INDEX VIEWS what is solution of this error SQL SCHEMABINDING Error

Veiw and its Advantages in Sql Server and What is INDEX VIEWS what is solution of this  error SQL SCHEMABINDING Error  View:--  A view is nothing more than a saved SQL query. A view can also be considered as a virtual table. A view is defined by a query and only shows the data which is defined at the time of creation of the view. If you hide particular columns then use the view. A view hides the complexity of the underlying...

Read More