91网首页-91网页版-91网在线观看-91网站免费观看-91网站永久视频-91网站在线播放

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 編輯過