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)