what does the "select @health as Health" do in this query pls - is a value stored anywhere

[droodle]

DECLARE @a integer
DECLARE @health integer

select @a = COUNT(*) from DB
where prid = 'com'
and (severity = 'minor'
or severity = 'major'
or severity = 'critical')

if @a = 0
BEGIN
SELECT @health = 100
END
if @a > 0
BEGIN
SELECT @health = 70
END

select @health as Health

 

[softhemc]

It returns one column which is called "Health" with the appropriate value ie 70 or 100.

as Health

simply names the output column - it does not necessarily refer to a specific column in table. This sort of syntax is often used for calculated columns or to make the column name more presentable for a user. For example if a table column is called "FIRSTNAME" you could use

SELECT FIRSTNAME as [First Name]

to make it look friendlier.

 

[gk53]

and statement

select @a = COUNT(*) from DB
where prid = 'com'
and (severity = 'minor'
or severity = 'major'
or severity = 'critical')

you can change to

select @a = COUNT(*) from DB
where prid = 'com'
and severity in ('minor', 'major', 'critical')