Define MSSQL

SQL Data Types

SQL Commands

SQL Create Database

SQL Create Table

SQL Insert Into

SQL Select Query

SQL Orderby

SQL Update Command

Truncate Delete Drop

SQL Select Top

SQL Constraints

SQL Alias

SQL Joins

SQL Union, intersect

SQL Select Into

SQL Insert Into Select

SQL Indexes

SQL Alter Table

SQL AutoIncrement

SQL View

SQL Date Functions


SQL Aggregate Functions

SQL Group By

SQL Scalar functions

Stored Procedure

MS-SQL Create Table

The CREATE TABLE statement is used to create a table in a database.
Create table customer (Id int, Name Varchar (20), Address Varchar (25), City Varchar (20), Postal_Code Varchar (20))

IDName AddressCityPostal_Code
2Aakriti A-45Delhi 110006
3Marry 1/5 Jaipur 302041
4Candy B-90Mumbai 400065
5Harry A-100Bhopal 462003
6Ramesh C-20 Delhi 110095
7Mukesh D-30 Indore 452085
8Komal E-50 Bhopal 462077
9Aakash F-90 Delhi 110056
10 Sammy B-55 Indore 452034