Just to clarify, it's not about coping the contents of the store procedure, it's about generating code to execute the stored procedure from another script.  For example...

declare @rc as int

decalre @arg1 as varchar(10)

decalre @arg2 as varchar(10)

set @arg1 = '???'

set @arg2 = '???'

execute @rc = usp_mystoredproc @arg1,@arg2

The second part of the question would be specific to a table (including column names).  It would be a nice timesaver (you know how lazy programmers can be :) ).