Wednesday , August 21 2019

Faheem

Faheem
An adaptable and responsible Software Engineer, who enjoys working with computers and the opportunity to learn new skills and work with new technologies is particularly attractive to me.

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 »