execute sql query dynamically

eg:
create proc pr_test
@table varchar(128),
@database varchar(128)
as

declare @str1 varchar(128)
declare @str2 varchar(128)

set @str2=' select * from '+@database+'.dbo.'+@table

exec (@str1+@str2)

转载于:https://www.cnblogs.com/Winston/archive/2008/01/17/1043082.html