UFN_SCHOOL_ISSINGLESCHOOL
Returns true if a single school database
Return
Return Type |
---|
bit |
Definition
Copy
CREATE function dbo.UFN_SCHOOL_ISSINGLESCHOOL()
returns bit
with execute as caller
as begin
declare @RETVAL int = 0;
--Don't return true if this is so far a "no school" database. In that case the School field needs to still show up to prompt the user to add a school.
SELECT @RETVAL = CASE WHEN (COUNT(dbo.SCHOOL.[ID]) = 1) THEN 1 ELSE 0 END
FROM dbo.SCHOOL
return @RETVAL;
end