34,587
社区成员
发帖
与我相关
我的任务
分享
if not exists(select * from master.dbo.sysdatabases where name = 'db_test')
begin
exec
('create database db_test
go
use db_test
');
end
WAITFOR DELAY '00:00:30'
--延迟30秒执行下面的SQL语句
if not exists(select * from master.dbo.sysdatabases where name = 'db_test')
begin
create database db_test;
exec ('use db_test;')
create table tt(id int identity(1,1) primary key ,name varchar(20));
insert into tt select 'zhang';
select * from tt;
drop table tt;
end
if not exists(select * from master.dbo.sysdatabases where name = 'db_test')
begin
create database db_test
go
use db_test
go
end
if not exists(select 1 from master.dbo.sysdatabases where name = 'db_test')
begin
exec ('create database db_test')
use db_test
end
if not exists(select * from master.dbo.sysdatabases where name = 'db_test')
begin
exec
('create database db_test');
end
go
use db_test