Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL ile XML sorgu kullanımı örnekleri içermektedir. 


Code Block
languagexml
titleXml
linenumberstrue
UPDATE	schYG_SeyahatRaporu
SET		ToplamHarcamalar=f.Data.value('sum(/formData/MasrafListesi/Data/Template/DonusmusTutar)' , 'nvarchar(50)') 
FROM 	wflWorkItems wi inner join
		wflFormData f on f.Id=wi.Data inner join 
		schYG_SeyahatRaporu r on r.FormId=wi.Id and r.ToplamHarcamalar=0 and 
		f.Data.value('sum(/formData/MasrafListesi/Data/Template/DonusmusTutar)' , 'nvarchar(50)')  <> '0.0E0'