Input nd output parameters Get link Facebook X Pinterest Email Other Apps April 05, 2019 CREATE PROCEDURE [ dbo ].[ GetPermission ] @ userName varchar ( 50 ), @ permission int output AS BEGIN select @ permission = PERMISSION from USERS where UserName = @ userName END ; Read more