因為tablename是個表名create proc view1
@tablename varchar(30)
as
set nocount on
set ansi_warnings offexec('select * from '+@tablename )go
@tablename varchar(30)
as
set nocount on
set ansi_warnings offexec('select * from '+@tablename )go
as
declare @mysql varchar(800)
set @mysql='select * from '''+@tablename+''''
exec (@mysql)
go
@tablename varchar(30)
as
exec('select * from '+@tablename )