if EXISTS (select * from authors where au_id = '172-32-1176')

Print 'Record exits - Update'

ELSE

Print 'Record doesn''t exist - Insert'