Create procedure Grammar

Create procedure pre_name
@ Variable list
as
pro_doby

eg. create procedure sp_getuserinformation
@ userid char (15) = '000000',
@ username char (2) output, // which means username is outout
@ address char (40) outout,
@ email char (30)
as
select userid, @ username = username, @ address = address, @ email = email
from t_userinfo
where userid = @ userid
// statements: if the parameter has default value when creating procedure, then when we call the procedure, we can igonore the parameters which makes no error.
eg. creat procedure sp_test
userid varchar (10) = '000000'
as
select * From t_username
where userid = @ userid;
go
when we call the procedure, we can write this:
à SP _ test (the default value of parameter userid is 982135, so we can ignore it)
or à SP _ test '000000'