SQL Server triggers

--when inserting data into the table "j0261", check that the number exists in the table "j026", insert if present, otherwise it will not be inserted. Create trigger Checkid on J0261instead of Insertasif (no exists (Slect * from j026 where study number = (select number from inserted))--If Insert j0261 of the data in the ' School number ' does not exist j026 table ROLLBACK TRANSACTION--rollback of an explicit or implicit transaction to the beginning of a transaction or to a savepoint within a transaction print ' The number of records to be processed does not exist ' elseinsert into j0261 SELECT * from inserted print ' record insert successful '