Posts

Showing posts with the label SQL Questions

Input nd output parameters

CREATE PROCEDURE [ dbo ].[ GetPermission ] @ userName varchar ( 50 ), @ permission int output AS BEGIN select @ permission = PERMISSION from USERS where UserName = @ userName END ;