SQL SORGUSU

[redne84]

ARKADAŞLAR AŞAGIDAKİ SORGUDA '001' YAZAN YERE X OLARAK BİR DEĞİŞKEN ATAMAK  İSTİYORUM NASIL YAPABİLİRİM.

SELECT     LG_001_CLCARD.CODE AS [Cari Kod], LG_001_CLCARD.DEFINITION_ AS [Cari Açıklama], LG_001_ITEMS.CODE AS [Stok Kodu],
                      LG_001_ITEMS.NAME AS [Stok Açıklaması], LG_001_01_ORFLINE.AMOUNT AS Miktar, LG_001_01_ORFLINE.TRCODE AS [SİPARİŞ TİPİ],
                      LG_001_01_ORFLINE.SHIPPEDAMOUNT AS [Sevkedilen Miktar], LG_001_01_ORFLINE.DATE_ AS TARİH, LG_001_01_ORFLINE.DUEDATE AS [TESLİM TARİHİ]
FROM         LG_001_01_ORFLINE INNER JOIN
                      LG_001_CLCARD ON LG_001_01_ORFLINE.CLIENTREF = LG_001_CLCARD.LOGICALREF INNER JOIN
                      LG_001_ITEMS ON LG_001_01_ORFLINE.STOCKREF = LG_001_ITEMS.LOGICALREF

[memorphin]

SQL değişken tanımlama özelliklerini inceleyin internette

DECLARE @DENEME NVARCHAR(20)
SET @DENEME='SELAMLAR'
SELECT @DENEME

------
SELAMLAR

Şeklinde yapabilirsiniz.