Monday , September 23 2019

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] int
);

INSERT INTO tblUser Values
(03,'Ibad','Ibad@yahoo.com','34sf',20),
(04,'Talha','Talha@yahoo.com','67sf',22)

INSERT INTO tblUser(Id,Name,Password,Email)Values (08,'Faizan','67sf','Faizan@yahoo.com')


SELECT Email,Password FROM tblUser

 

 

About 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.

Check Also

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

Get Torrent File Of SQL Server 2008 R2 Related

Leave a Reply

Your email address will not be published.