MS SQL Server Archives - Page 2 of 2 -

CREATE TABLE in MS SQL Server

In Microsoft SQL Server, there are different ways in which we can create the table. The table can be created with or without constraints. Basic Syntax for creating a table is, databaseName – Name of the DB where the table will be created tableName – Name of the table. columnName – Name of the column… Read More »

Types of SQL Statements in MS SQL Server

There are different types of statements that can be executed in SQL Server for different purposes. These are basically categorized into four types DDL – Data Definition Language DML – Data Manipulation Language DCL – Data Control Language TCL – Transaction Control Language DDL(Data Definition Language) The name itself suggests that it defines the structure… Read More »