SQL 常用語(yǔ)句：

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

設(shè)置主鍵：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 數(shù)據(jù)表名稱(chēng)

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

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

修改字段：ALTER TABLE [表名] ALTER COLUMN [字段名] 類(lèi)型(大小) NULL

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

刪除約束：ALTER TABLE [表名] DROP CONSTRAINT 約束名

新建默認(rèn)值：ALTER TABLE [表名] ADD CONSTRAINT 默認(rèn)值名 DEFAULT '51WINDOWS.NET' FOR [字段名]

刪除默認(rèn)值：ALTER TABLE [表名] DROP CONSTRAINT 默認(rèn)值名

該文章在 2011/6/21 23:13:39 編輯過(guò)