TSQL Common Statements

Create/Delete Database

if object_id (N'mytest'is notnulldropDATABASE  mytest; GO Create DATABASE mytest; Go

View Database

 Use mytest; Select name, size, size*1.0/as[size in MBs  ]from  where name='mytest' ;

Create a table

Create Table int Primary Key varchar (+));

Modify Table Structure

Alter Table Add int;

Note: Aliases for tables cannot be used here.

Inserting data

UsermytestGoDeclare @i int;Set @i = 1; while @i <  -begin  Insert  intoDbo.t_user (Id,name)Values(@i,'name_' + Convert(varchar( -),@i)); Set @i = @i + 1;End;

Insert data can be inserted in a single record or in bulk.

Operation table (Increase, delete, change)

Select *  from T_user; Delete  from T_user; update t_user  set=1 ;

TSQL Common Statements