DEFINITIONS

Definitions More Info.
Definition ID4.032
TitleSQL
CategoryNOTES
Definitionlinked scalar function, fonksiyondan parametreli sonuc alma
Definition DescriptionDECLARE @TSQL varchar(8000)
DECLARE @Sonuc varchar(100)
DECLARE @tarih DATE
DECLARE @table TABLE (status1 varchar(20))
DECLARE @OrganizerMusteriKod INT
SET @tarih='20200920'
SET @OrganizerMusteriKod=5806
--SELECT CONVERT(varchar(15),@tarih)

-- SQL den SQL e scalar fonksiyon sonucunu parametreli olarak ancak asagidaki gibi alabiliyoruz.
SELECT @TSQL='SELECT * FROM OPENQUERY([ORGDB02],''SELECT [Organizer].[dbo].[GetBasvuruDurum] ('''''+CONVERT(varchar(12),@tarih,112)+''''','+CONVERT(varchar(5),@OrganizerMusteriKod)+')'')'

--PRINT (@TSQL)

INSERT INTO @table(status1)
EXECUTE (@TSQL)

SELECT * FROM @table
RecordBycunay
Record Date29-09-2020 15:44:17
Düzenle
Kopyala
Sil