--- with paras create procedure myProName @tname as select * from yourTable where tname=@tname
---define paras in SP CREATE PROCEDURE proc2 AS DECLARE @middle_init char(1) SET @middle_init = NULL SELECT au_id, middle_initial = @middle_init FROM authors
create procedure myProName @tname as select * into #t from yourTable where tname=@tname update #t set Field1='aaa' select * from #t
create procedure myProName
@tname
as
select * from yourTable
where tname=@tname
CREATE PROCEDURE proc2
AS
DECLARE @middle_init char(1)
SET @middle_init = NULL
SELECT au_id, middle_initial = @middle_init
FROM authors
@tname
as
select * into #t from yourTable
where tname=@tname
update #t
set Field1='aaa'
select * from #t