Simple Trigger

--Create Table
Create table TestTriger
(
Tranid int ,
Locationid int
)

--Create Trigger
Create TRIGGER [dbo].TestTriger_LocationChk
ON  [dbo].TestTriger
AFTER Insert
AS

DECLARE @LocId Numeric(15,6)

select @LocId = Locationid from Inserted


if @LocId = 0
BEGIN
    RAISERROR('LocCheck Zero Inserting. Please Contact Administrator...', 16, 1);
    ROLLBACK TRANSACTION
END

--Insert query to check trigger
Insert into TestTriger values(1,0)