INSERT INTO

INSERT INTO

--=========================[ INSERT INTO ]===================================================

--This is used to add a new row into the database table.

--Insert Into Table (Use AdventureWorks Database)--

INSERT INTO Person.Contact

VALUES ('2998', '0','Mr.','Habibar','Rahman','Sheikh'.....)

--Insert Into Table (in specified column)

INSERT INTO Person.Contact (FirstName, LastName,Phone,EmailAddress,PasswordHash,PasswordSalt)

VALUES ('Habib', 'Sheikh', '9985476188', 'habib.mvp@gmail.com','jhshdhsjkddujiushdfijmujsgudh','uyuhjs=')

SELECT * FROM Person.Contact

WHERE LastName Like 'sheik%'