摘要: 1 判断数据库是否存在if exists (select * from sys.databases where name = '数据库名') drop database [数据库名]2 判断表是否存在if exists (select * from sysobjects where id = object_id(N'[表名]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [表名]3 判断存储过程是否存在if exists (select * from sysobjects whe 阅读全文
posted @ 2013-05-10 09:06 L嗜血幽灵 阅读(73) 评论(0) 推荐(0) 编辑