Now we’ll create a user-defined function that can determine whether a user has ever logged in before, as well as how many times the user has logged in:

Transcribed Image Text:

USE Chapter6; GO CREATE FUNCTION dbo.fn_Count Logins (@UserName varchar (50)) RETURNS int AS BEGIN Declare @Logins int SELECT @Logins = COUNT(*) FROM AuditAccess WHERE UserName = @UserName Return @Logins END; USE Chapter6; GO CREATE FUNCTION dbo.fn_Count Logins (@UserName varchar (50)) RETURNS int AS BEGIN Declare @Logins int SELECT @Logins = COUNT(*) FROM AuditAccess WHERE UserName = @UserName Return @Logins END;