CREATE PROCEDURE au_info_all
ASexec('create view v1 as select 1 as a ')
select * from v1
drop view v1
GO
exec au_info_allgo
drop PROCEDURE au_info_all
ASexec('create view v1 as select 1 as a ')
select * from v1
drop view v1
GO
exec au_info_allgo
drop PROCEDURE au_info_all
解决方案 »
- Sql Server 表结构修改问题
- sql语句的问题。高手帮忙进来看看
- scalar-valued function 是什么意思
- create index创建的是什么类型的索引?
- 邹建来看看
- 如何隨機刪除table中的一條數據?
- 心情好,项目完成了。散分,报恩!
- varchar型转换成Datetime型,可以吗,怎么做?
- 编写的sql文件怎么使用
- access数据库导出到表中excel
- 请问在DTS里面设计包中用到发送邮件任务时要求必须安装消息传递服务MAPI初始化失败,我该怎么做?
- 请教能否用应用程序实现对SQL Svever2000的设置?例如:我不用打开数据库,就用应用程序来设置一个作业。
CREATE PROCEDURE dbo.au_info_all
AS
declare @sql varchar(8000)
begin
set @sql = 'create view v1 as select 1 as t'
EXEC(@sql)
end
select * from v1
drop view v1GO
exec dbo.au_info_all
AS
if exists(select 1 from sysobjects where id=object_id('v1'))
drop view v1
create view dbo.v1 as select 1 as t
end
select * from t
GOif exists(select 1 from sysobjects where id=object_id('ter'))
drop view ter