IIF ve IF komutu

Post Reply
ahmet
Site Admin
Posts: 66
Joined: Tue Feb 23, 2021 6:54 pm

IIF ve IF komutu

Post by ahmet »

iif komutu

Code: Select all

declare @search_id varchar(20)='8696848011092'

SELECT top 1 [urunid],[barkod],[miktar],bb.[id],[urunadi],[parabirimi],[fiyat],[kdv],[tur],[bar_birim], bb.bar_fark 
,((IIF (bar_fark = 0,1,1+convert(numeric(18,6), bar_fark)/100)* fiyat)*(1+convert(numeric(18,6), kdv)/100))*d.satis  as barliFiyat
 , d.satis 
  FROM [barkod_barcode] as bb
left join barkod_urunler as u on u.id = bb.urunid
left join [dbo].[ayarlar_doviz] as d on d.kisaltma=u.parabirimi 
WHERE barkod=@search_id
if komutu

Code: Select all

DECLARE @S integer;
declare @anahtar varchar(50) ='Anahtar';
declare @deger varchar(50) = '70';

set @s = (SELECT count([anahtar]) FROM [BARDATA].[dbo].[ayarlar_varsayilanlar] where anahtar=@anahtar)

if @s =0 begin
INSERT INTO bardata.[dbo].[ayarlar_varsayilanlar] ([anahtar],[deger]) VALUES (@anahtar ,@deger)

end
else begin
UPDATE bardata.[dbo].[ayarlar_varsayilanlar] set [anahtar]=@anahtar, [deger]=@deger where anahtar=@anahtar

end;
Post Reply