Priklad deklaracia SET IF ELSE

declare @priznak as char(20)

set @priznak = (SELECT top 1 zal2  FROM   Nastavenia)
print @priznak
if @priznak = 'True'
   Begin
	 SELECT     *
         FROM         Vzor2004
         WHERE     (ExportEMcard = 1) AND (NOT (SNR IS NULL)) AND (SNR <> 0)
   end
else	
   Begin
	 SELECT     *
         FROM         Vzor2004
         WHERE     (ExportEMcard = 1) and  (CD01_DruhKarty = 1) AND (NOT (SNR IS NULL)) AND (SNR <> 0)
   end

v trigri:

 if (SELECT top 1 OrderItemCardsHistoryID  FROM  OrderItemCardsHistory WHERE OrderItemID = (SELECT i.OrderItemID FROM inserted i ) AND CardProcessStateTypeID = (SELECT i.CardProcessStateTypeID FROM inserted i )) is null
   Begin
...
   End

P. Mraz, S. Kuchar