Create ,Alter,Drop In SQL server

Create Table In SQL server

CREATE TABLE STUDENT

(

  Name Varchar(20),

  Housename varchar(20),

  Age int,

 

)

SELECT * FROM STUDENT

Declare Temtable In SQL server

DECLARE @TEMTAB TABLE

(

  Name VARCHAR(20),

  Age INT

)

INSERT INTO @TEMTAB VALUES('MARK',30)

--TO INSERT YOUR SELECTED TABLE DATA TO TEMP TABLE FIRST YOU MUST DECLARE YOUR TABLE FIELED

--INSERT INTO @TEMTAB

--SELECT * FROM TABLENAME

SELECT * FROM @TEMTAB

Add and Drop Column From Table  

ALTER TABLE STUDENT ADD   POST VARCHAR(20)

SELECT * FROM STUDENT

ALTER TABLE STUDENT

DROP COLUMN POST

SELECT * FROM STUDENT

Insert ,Select,Update,Delete In SQL serevr

Insert ,Select,Update,Delete In SQL serevr

Insert one Row to Accountmaster  

INSERT INTO Accountmaster VALUES(125,'JHON',8,2000)

Seletect  Accountmaster

SELECT * FROM Accountmaster

Select One row with where condition from Accountmaster 

SELECT * FROM Accountmaster WHERE AcNo=125

Update Accountmaster

UPDATE Accountmaster SET [ACNAME]='JHON MARK',[AGE]=25 WHERE AcNo=125

Delete All account

DELETE FROM Accountmaster

Delete one Row

DELETE FROM Accountmaster WHERE AcNo=125