1、插入记录
insert into tableName (myColumn1,myColumn2) values ( @myVal1 , @myVal2 )
2、删除记录
delete from tableName where myColumn = @myVal
3、修改记录
update from tableName set myColmn1 = @myVal1 , myColmn2 = @myVal2 where myColmn3 = @myVal3
4、为表增加列
alter table myTable add myColumn int default 0
5、删除表中的列
alter table myTable drop column myColumn
6、删除列的依赖关系
alter table a drop CONSTRAINT DF_TreeView_rank
exec sp_rename ' orders.p_id ' , ' product_id ' , ' column '
insert into tableName (myColumn1,myColumn2) values ( @myVal1 , @myVal2 )2、删除记录
delete from tableName where myColumn = @myVal3、修改记录
update from tableName set myColmn1 = @myVal1 , myColmn2 = @myVal2 where myColmn3 = @myVal34、为表增加列
alter table myTable add myColumn int default 05、删除表中的列
alter table myTable drop column myColumn6、删除列的依赖关系
alter table a drop CONSTRAINT DF_TreeView_rank7、利用系统存储过程更改orders 表的列p_id 名称为products_id
exec sp_rename ' orders.p_id ' , ' product_id ' , ' column '
版权声明：本文为luck0235原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。