Triggers in SQL Server
A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The t
View in SQL Server
A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables. Based on this, before creating a view, you must first decide where its columns and records
Join in SQL Server
JOIN is used whenever we have to select data from two or more tables. To be able to use JOIN to extract data from we need a relationship between certain columns in the tables.
Stored Procedure in Microsoft SQL Server
Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a com
Create Table in Microsoft SQL Server
Syntax to create table in MSSQl Server2008CREATE TABLE table [name]( Column1 Column2 Column3ExampleCustomers is the name of table.CREATE TABLE Cu