IIF ve IF komutu
Posted: Sun Apr 09, 2023 7:12 pm
iif komutu
if 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
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;