Sunday , December 6 2020
Home / SQL Server

SQL Server

SQL Server Tutorials.

SQL Server: 07 – INSERT and SELECT Statement

  INSERT Statement Syntax: INSERT INTO TABLE_NAME (column1, column2, column3,…columnN)] VALUES (value1, value2, value3,…valueN); SELECT Statement Syntax: SELECT column1, column2, columnN FROM table_name;   CREATE DATABASE Test01 USE Test01 CREATE TABLE tblUser ( [ID] int NOT NULL, [Name] varchar(50) NOT NULL, [Email] varchar(50) NOT NULL, [Password] varchar(50) NOT NULL, [Age] …

Read More »

SQL Server: 06 – ALTER and DROP Statement

ALTER Statement in SQL To add a column in a table, use the following syntax: ALTER TABLE table_name ADD column_name datatype To delete a column in a table, use the following syntax: ALTER TABLE table_name DROP COLUMN column_name  

Read More »

SQL Server: 05 – CREATE Statement

CREATE Statement: Syntax: CREATE DATABASE database_Name; Syntax: CREATE TABLE table_name( column1 datatype, column2 datatype, column3 datatype, ..... columnN datatype, PRIMARY KEY( one or more columns ) );  

Read More »

SQL Server: 04 – T-SQL Statemetns Categories

  The four main categories of SQL statements are as follows: DML (Data Manipulation Language) 2. DDL (Data Definition Language) 3. DCL (Data Control Language) 4. TCL (Transaction Control Language) DML (Data Manipulation Language) DML statements affect records in a table. These are basic operations we perform on data such …

Read More »

SQL Server: 03 – Complete Installation Of SQL-Server 2008 R2

Get Torrent File Of SQL Server 2008 R2

Read More »

SQL Server: 02 – Introduction of ER-Model

Introduction of ER-Model

   

Read More »

SQL Server: 01 – Introduction of SQL Server

Introduction of SQL Server

Introduction of SQL Server Data and Database: Data means information and it is the most important component in any work that is done. A Database is a collection of data. Some like to think of a database as an organized mechanism that has the compatibility of storing information Data Management …

Read More »