按照道理来说 if object_id('pro_test1') is not null drop proc pro_test1 create proc pro_test1...go if object_id('pro_test2') is not null drop proc pro_test2 create proc pro_test2...go这样是可以同时执行的
用 go 区分开 create database.... go use mydb go create table go ..........create 语句前面是不允许有其它语句的, 所以你的把他们分开
if object_id('pro_test1') is not null
drop proc pro_test1
create proc pro_test1...go
if object_id('pro_test2') is not null
drop proc pro_test2
create proc pro_test2...go这样是可以同时执行的
create database....
go
use mydb
go
create table
go
..........create 语句前面是不允许有其它语句的,
所以你的把他们分开