摘要: use mastergoif exists(select name from sys.databases where name='Data')drop database Datagocreate database Datagouse Datagoif exists(select name from sys.objects where name='studentOne')drop table studentOnegocreate table studentOne( studentName nvarchar( 10 ), studentSubject nvarcha 阅读全文
posted @ 2011-08-17 00:46 Curitis 阅读(215) 评论(0) 推荐(0) 编辑
摘要: --数据的批量插入if exists(select name from sys.databases where name='DB_Test')drop database DB_Testgocreate database DB_Testgouse DB_Testgoif exists(select name from sys.objects where name='T_Table1')drop table T_Table1gocreate table T_Table1( a nvarchar(10),--姓 b nvarchar(10),--性别 c int,-- 阅读全文
posted @ 2011-08-17 00:21 Curitis 阅读(236) 评论(0) 推荐(0) 编辑