摘要:
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 阅读全文
摘要:
--数据的批量插入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,-- 阅读全文