Sql语句收集

1:添加数据

a：SELECT id, name, address INTO table2 FROM table1——自动创建table2，T-sql用法;

b：INSERT INTO table2(id, name, address) SELECT id, name, address FROM table1 

 

//修改字段的类型 

alter table fdi_news alter column c_author nvarchar(50) 

//重命名字段的名称 

EXEC sp_rename 'FDI_PROJECT.[c_foreignCountryPer]','c_foreignCompanyPer','COLUMN'; 

//增加字段 

alter table fdi_news add c_author nvarchar(50) 

//删除字段 

alter table fdi_news drop c_author nvarchar(50)