SQL 常用语句：

创建表：
CREATE TABLE [表名] (
[test1] int not null identity,
[test2] binary not null,
primary key ([test1]))

设置主键：ALTER TABLE [tablename] ADD PRIMARY KEY ([fieldname])

查询：select * from tablename where fieldname *** order by id desc

更新：update tanlename set fieldname = values,cn_name='values' where ID = 1

添加：insert into tanlename (fieldnam,fieldnam2)values (1,'values')

删除：delete from tanlename where fieldname = values

删除表：DROP TABLE 数据表名称

添加字段：ALTER TABLE [表名] ADD [字段名] NVARCHAR (50) NULL

删除字段：alter table [tablename] drop [fieldname]

修改字段：ALTER TABLE [表名] ALTER COLUMN [字段名] 类型(大小) NULL

新建约束：ALTER TABLE [表名] ADD CONSTRAINT 约束名 CHECK ([约束字段] <= '2000-1-1')

删除约束：ALTER TABLE [表名] DROP CONSTRAINT 约束名

新建默认值：ALTER TABLE [表名] ADD CONSTRAINT 默认值名 DEFAULT '51WINDOWS.NET' FOR [字段名]

删除默认值：ALTER TABLE [表名] DROP CONSTRAINT 默认值名

该文章在 2011/6/21 23:13:39 编辑过