Tables in Sql Server stores data in the form of Rows and columns. Below is the basic syntax for creating Table in Sql Server. CREATE TABLE <TableName> ( <ColumnName1> <Datatype> [CONSTRAINT], <ColumnName2> <Datatype> [CONSTRAINT], . . <ColumnNameN> <Datatype> [CONSTRAINT] ) Example: CREATE TABLE Customer ( CustomerId INT NOT NULL, Name NVARCHAR(100) NOT NULL, PhoneNumber VARCHAR(15)Continue reading “TABLE”
Author Archives: allaboutsqlsite
DATABASE
A Database in SQL Server consists of mainly database objects like Tables, Stored Procedures, User Defined Functions, Views and so on. A database instance will usually be having multiple System Defined databases and User created databases. MASTER,MSDB,MODEL and TEMPDB databases are the System Databases which shipped with SQL Server by default. SYSTEM DATABASE DESCRIPTION MASTERContinue reading “DATABASE”
SQL BASICS
SQL is a standard language for storing, manipulating and retrieving data in databases. SQL stands for Structured Query Language SQL can use for create new databases SQL can use for create table and insert records in a database SQL can use for select data from table in database SQL can use for update and deleteContinue reading “SQL BASICS”
STEP BY STEP SQL 