[all] -------- union合并查询结果集，all-保留重复行
 select stockname from table2
insert
insert into table_name (Stock_name,Stock_number) value ("xxx","xxxx"
value (select Stockname , Stocknumber from Stock_table2)
-------value为select语句
update
update table_name set Stockname = "xxx" [where Stockid = 3]
Stockname = default
Stockname = null
Stocknumber = Stockname + 4
delete
delete from table_name where Stockid = 3
truncate table_name --------- 删除表中所有行，仍保持表的完整性
drop table table_name --------- 完全删除表
alter table -------- 修改数据库表结构
alter table database.owner.table_name add column_name char(2) null  ..
sp_help table_name -------- 显示表已有特征
create table table_name (name char(20), age smallint, lname varchar(上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] ... 下一页 >> |
