I want to create a proc that pulls either a single record based in the RecId or all
records if no Id was passed in.
What am I doing wrong here?
CREATE PROCEDURE syGetUser
@RecId integer = NULL
AS
SELECT RecId,
GroupId,
FullName
UserName,
Password
FROM appUsers
WHERE (RecId = @RecId) OR ISNULL(@RecId)
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people