I am reviewing SQL coding and I noticed that @ symbol repeats so many times. I am also posting the sample code for you to review.
My question is what is usually represented by @ symbol within SQL.
Thank You, A.
create proc mic_is_in_role
@RoleName varchar(24) = null,
@loginId varchar(16) = null
--DESCRIPTION: returns 0 if user login id is in role, otherwise returns a value less than 0
set nocount on
if (@RoleName is null OR @loginId is null) begin
if exists (select *
where RoleName = @RoleName
and LoginId = @loginId) begin
return 0 -- yes, loginid is in role
end else begin