急,急,急。各位Help me create proc test (@sql varchar(8000))as exec('Alter view view_name as '+@sql) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 try:create procedure test @sql varchar(4000)As Exec('alter view vName as '+@sql)go CREATE PROCEDURE abcd @bbc varchar(10) ASdeclare @str varchar(1000)set @str='alter view view1 as select * from ' + @bbc exec (@str)GO create procedure test @sql varchar(4000)As Exec('alter view vName as '+@sql)go create procedure test @sql varchar(8000)As Exec(’Alter view vName as ‘+@sql)go 我发给你的这个例子 可以吗use pubsgocreate view vi_au as select * from authorsgocreate proc sp_changeview (@sql varchar(1000))asexec ( 'alter view vi_au as ' + @sql)exec sp_changeview 'select * from jobs' create procedure test @sql varchar(4000)As Exec('alter view vName as '+@sql)go 联系查询问题 SQL-DMO(ODBC SQL State:42000),这个问题怎么解决,请高手帮忙! 问个MS SQL SERVER2000的问题,希望高手解答... 关于MIS数据库中某表某字段值在修改时,产生的数据参照完整性问题?? 帮我看一下一个存储过程的问题![UP有分] 求一SQL统计语句!! 大家帮忙看下这个in的用法有什么问题 我的sa帐户不能用了 select中怎么进行判断计算 关于一个select 查询,请大力,邹键帮帮我,谢谢@!~~~ 请问那有SQL的完全下载啊 sql sever2000安装问题
create procedure test @sql varchar(4000)
As
Exec('alter view vName as '+@sql)
go
declare @str varchar(1000)set @str='alter view view1 as select * from ' + @bbc
exec (@str)
GO
As
Exec('alter view vName as '+@sql)
go
As
Exec(’Alter view vName as ‘+@sql)
go
use pubs
gocreate view vi_au
as
select * from authorsgocreate proc sp_changeview (@sql varchar(1000))
as
exec ( 'alter view vi_au as ' + @sql)
exec sp_changeview 'select * from jobs'
As
Exec('alter view vName as '+@sql)
go