CREATE PROCEDURE dbo.cx @km varchar(7),@dm int AS
declare @a varchar(8000)
set @a='select * from '+@km+' where 代码='+cast(@dm as varchar(10))
exec(@a) go
declare @a varchar(8000)
set @a='select * from '+@km+' where 代码='+cast(@dm as varchar(10))
exec(@a) go
CREATE PROCEDURE dbo.cx @km char(7),@dm int AS exec('select * from ['+@km+'] where 代码='''+@dm+'''' go