home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a061 / 1.img / CLIENT1 / ACT14A.QRY < prev    next >
Encoding:
Text File  |  1992-02-21  |  245 b   |  11 lines
  1. create trigger delauthor
  2. on authors
  3. for delete
  4. as
  5. if (select count(*) from deleted, titleauthor
  6. where titleauthor.au_id = deleted.au_id) > 0
  7.    begin 
  8.    rollback transaction
  9.    print 'You can''t delete an author with a title.'
  10.    end
  11.