SQL Server Óï¾ä²éѯÊÖ²á

½¨±í£º
CREATE TABLE  [DB.dbo].tableName
(Stud_id int CONSTRAINT  constraintName1  not null primary key,
 Name nvarchar(5) not null,
 Birthday datetime,
 Gender nchar(1),
 Telcode char(12),
 Zipcode char(6) CONSTRAINT constraintName2 CHECK(zipcode like [0-9] [0-9] [0-9] [0-9] [0-9] [0-9] [0-9]),
 Deptcode tinyint CONSTRAINT constraintName3 check(Deptcode<100),
 Salary money DEFAULT 260
)
ɾ±í£º
DROP TABLE tableName ;
 ÐÞ¸Ä±í£º
ALTER TABLE [DB.dbo.]tableName
ADD column_Name nvarchar(20) not null DEFAULT ‘liaihua’;
ALTER TABLE [DB.dbo.]tableName
DROP COLUMN column_Name;
ALTER TABLE [DB.dbo.]tableName
MODIFY column_Name columnType;
²åÈëÊý¾Ý£º
Insert into tableName[(column1,column2,column3…)] values(value1,value2,value3….);
Insert into tableName[(column1,column2,column3…)] select column1,column2,column3… from tableName2 [where…]
¸üÐÂÊý¾Ý£º
Update tableName set column1=value1,column2=value2,column3=value3…..where…
ɾ³ýÊý¾Ý£º
Delete from tableName where ……
²éѯÊý¾Ý£º
Select  [ALL|DISTINCT] column1,column2,column3….. from tableName1[,table2,table3...]
[Where ……]
[Group by column_Name]
[Having …..]
[Order by column_Name [desc|asc]]
³£Óü¯º¯Êý£º
SUM();AVG();MIN();MAX();COUNT();
SQL Server Ö§³ÖÎåÖÖÔ¼Êø£ºDEFAULTÔ¼Êø£¨Ä¬ÈÏÔ¼Êø£©£»PRIMARY KEYÔ¼Êø£¨Ö÷¼üÔ¼Êø£©£»CHECKÔ¼Êø£¨¼ì²éÔ¼Êø£©£»FOREIGN KEYÔ¼Êø£¨Íâ¼üÔ¼Êø£©£»UNIQUEÔ¼Êø£»
Ô¼ÊøµÄ´´½¨£º
CREATE TABLE tableName
(column1 Type (null|not null)
[[CONSTRAINT constraintName]                   -----Ô¼ÊøÃûÈç¹û²»Ð´£¬ÏµÍ³×Ô¶¯¼ÓÉÏ
{
  PRIMARY KEY [CLUSTERED|NONCLUSTERED]
  |UNIQUE [CLUSTERED|NONCLUSTERED]
  |[FOREIGN KEY] REFERENCES ref_table[(ref_column)]
  |default constraintExpression
}
][,column2……]
)
Ô¼ÊøµÄ