大家看看这个经典吗？都是自己总结的。供大家学习
if exists(select * from sys.procedures where name='c')
drop proc c
go
create proc c
as
if db_id(N'a')is not null
drop database a
go
create database a
on
(name='a',
filename='d:\a.mdf',size=8,maxsize=9,filegrowth=5)
log on
(name='aa',
filename='d:\aa.ldf',size=7,maxsize=8,filegrowth=5)
go
use a
go
if exists(select * from sys.tables where name='w')
drop table w
go
select * into w from test.dbo.stu where 1=2 --test数据库里有表stu
go
insert into w(name,age,sex,address)
select name,age,sex,address from test.dbo.stu
except
select name,age,sex,address from w
go
[最优解释]
不管经典不经典，自己多总结总是有好处滴
[其他解释]
恩恩，和你学到好多东西，我的分数基本都给你你了。应该的啊。呵呵
[其他解释]
同意楼上的，DBA姐姐确实才高八斗啊
[其他解释]
