一个SQL,手头没资料,急用,谁帮我写一下 select Clm_2 as Clm_1 from .... 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我是要修改数据库,而不是select数据。 ALTER TABLE [ owner .]table-name ... ADD column-definition [ column-constraint ... ]| ADD table-constraint | MODIFY column-definition | MODIFY column-name DEFAULT default-value | ALTER column-name SET DEFAULT default-value | ALTER column-name DROP DEFAULT | ALTER column-name SET COMPUTE ( expression )| ALTER column-name DROP COMPUTE | MODIFY column-name [ NOT ] NULL | MODIFY column-name CHECK NULL | MODIFY column-name CHECK ( condition )| { DELETE | DROP } column-name | { DELETE | DROP } CHECK | { DELETE | DROP } UNIQUE ( column-name , ... )| { DELETE | DROP } PRIMARY KEY | { DELETE | DROP } FOREIGN KEY role-name | RENAME new-table-name | RENAME column-name TO new-column-namecolumn-definition :column-name data-type [ NOT NULL ] [ DEFAULT default-value ]column-constraint :{ UNIQUE | PRIMARY KEY | REFERENCES table-name [ ( column-name ) ] [ actions ]} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]| CHECK ( condition )| COMPUTE ( expression )default-value :string | global variable | number | AUTOINCREMENT | CURRENT DATE | CURRENT TIME | CURRENT TIMESTAMP | NULL| TIMESTAMP | USERtable-constraint :{ UNIQUE ( column-name , ... )| PRIMARY KEY ( column-name , ... )} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]| CHECK ( condition )| foreign-key-constraintforeign-key-constraint :[ NOT NULL ] FOREIGN KEY [ role-name ] [ (column-name , ... ) ]... REFERENCES table-name [ (column-name , ... ) ]... [ actions ] [ CHECK ON COMMIT ]... [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]actions :[ ON UPDATE action ] [ ON DELETE action ]action :CASCADE | SET NULL | SET DEFAULT | RESTRICTALTER TABLE [ owner .]table-name ... REPLICATE { ON | OFF } 改名:ALTER TABLE [ owner .]table-name RENAME column-name TO new-column-name ALTER TABLE [ owner .]table-name ... ADD column-definition [ column-constraint ... ]| ADD table-constraint | MODIFY column-definition EXEC sp_rename 'Table_1.Clm_1', 'Clm_2', 'COLUMN' 选出每个父类ID=0的新闻1条 数据库记录更新不了 这个sql语句应该怎么写? 请教 sql server存储过程查询时间过长的问题,救命啊 bcp命中能有参数不 请教:这个作业为什么不能执行? 高手请进,sql能否实现排序算法 整数200表示成200.00?小数200.5表示成200.50怎么写?小数200.518表示成200.52怎么写?(四舍五入的). 请问怎么样将*.HTM中数据转化为SQL中 如何创建ODBC连接 急求:调用问题!!
... ADD column-definition [ column-constraint ... ]
| ADD table-constraint
| MODIFY column-definition
| MODIFY column-name DEFAULT default-value
| ALTER column-name SET DEFAULT default-value
| ALTER column-name DROP DEFAULT
| ALTER column-name SET COMPUTE ( expression )
| ALTER column-name DROP COMPUTE
| MODIFY column-name [ NOT ] NULL
| MODIFY column-name CHECK NULL
| MODIFY column-name CHECK ( condition )
| { DELETE | DROP } column-name
| { DELETE | DROP } CHECK
| { DELETE | DROP } UNIQUE ( column-name , ... )
| { DELETE | DROP } PRIMARY KEY
| { DELETE | DROP } FOREIGN KEY role-name
| RENAME new-table-name
| RENAME column-name TO new-column-namecolumn-definition :
column-name data-type [ NOT NULL ] [ DEFAULT default-value ]column-constraint :
{ UNIQUE
| PRIMARY KEY
| REFERENCES table-name [ ( column-name ) ] [ actions ]
} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]
| CHECK ( condition )
| COMPUTE ( expression )default-value :
string
| global variable
| number
| AUTOINCREMENT
| CURRENT DATE
| CURRENT TIME
| CURRENT TIMESTAMP
| NULL
| TIMESTAMP
| USERtable-constraint :
{ UNIQUE ( column-name , ... )
| PRIMARY KEY ( column-name , ... )
} [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]
| CHECK ( condition )
| foreign-key-constraintforeign-key-constraint :
[ NOT NULL ] FOREIGN KEY [ role-name ] [ (column-name , ... ) ]
... REFERENCES table-name [ (column-name , ... ) ]
... [ actions ] [ CHECK ON COMMIT ]
... [ WITH [ MAX | MAXIMUM ] HASH SIZE hash-size ]actions :
[ ON UPDATE action ] [ ON DELETE action ]action :
CASCADE
| SET NULL
| SET DEFAULT
| RESTRICTALTER TABLE [ owner .]table-name
... REPLICATE { ON | OFF }
ALTER TABLE [ owner .]table-name RENAME column-name TO new-column-name
... ADD column-definition [ column-constraint ... ]
| ADD table-constraint
| MODIFY column-definition