IF STATEMENT ON A SELECT?

[JONBOY74]

Hi all

Can you use IF statements with select statements so that, a error messege appears in place of the selected data if that data doesn't exist.

Any help or pointer please

Jon

 

[RickCole]

Yes you can user IF statements i.e.

If (select count(*) from call_type) = 0
print 'No records returned'
else
print 'There are records'


Rick.

 

[grahamm]

If you're talking about T-SQL in a stored procedure thenyou can use the builtin @@rowcount variable:

select ... from ... where
if @@rowcount=0
begin
print "No Records Matched"
return
end