CREATE PROCEDURE [chaxun]
(
@tablename char(20)
)
AS
declare @sql varchar(8000)
set @sql='select * from ' + @tablename
exec (@sql)
go
(
@tablename char(20)
)
AS
declare @sql varchar(8000)
set @sql='select * from ' + @tablename
exec (@sql)
go
调试欢乐多
exec [chaxun] t
(
@tablename char(20)
)
AS
exec('select * from'+ @tablename )
(
@tablename char(20)
)
AS
exec('select * from '+ @tablename )
from 要有一个空格,不然会出错.