Thursday , July 7 2022
Home / SQL Server / SQL Server: 07 – INSERT and SELECT Statement

SQL Server: 07 – INSERT and SELECT Statement

generic Aurogra without prescription January 20, 2016 SQL Server Leave a comment 1,287 Views


 

buy Ivermectin ivermectin INSERT Statement Syntax:

INSERT INTO TABLE_NAME (column1, column2, column3,…columnN)]

VALUES (value1, value2, value3,…valueN);

can i buy Pregabalin online in uk 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

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

Leave a Reply

Your email address will not be published.