T-SQL基本语句

/*T-SQL基本语句*/--自定义创建数据库,如果使用默认设置侧只需要create database name一行代码if DB_ID('test') is not nulldrop database testgocreate database m_databaseNameon(name = m_databaseName_data,filename = 'x:\path\m_database_data.mdf',size = 6,maxsize = 12,filegrowth = 10%)log on(name = m_databaseName_log,filename = 'x:\path\m_database_log.ldf',size = 1,maxsize = 8,filegrowth = 10%)--添加数据库文件alter database testadd file(name=test2_data,filename='c:\demo\test2_data.mdf',size=3,maxsize=6,filegrowth=10%)--删除数据库文件alter database testremove file test2_data--创建表create table demo(id int not null,name varchar(26) not null,age int not null,email varchar(30))--改表名exec sp_rename 'demo','demo2'--删除表drop table demo--添加字段alter table demoadd addr varchar(30)--修改字段名exec sp_rename 'tableName.columnName','newName','column'--修改字段类型alter table demoalter column columnName type--删除字段alter table demodrop column columnName--插入记录insert into tableName values(value1,value2,......) --填充所有列insert into tableName(column1,column2,......) values(value1,value2,......) --填指定列，须满足非空约束--修改记录update tableName set column1=value1,column2=value2,..... where columnX=N --满足where条件的记录将被修改update tableName set id=id*10 --在更新记录时可以根据原值作运算--删除记录delete from tableName --删除所有记录delete from tableName where columnX=N --有条件的删除