Common Table Expressions (CTEs) : Common Table Expressions (CTEs) sql...

Sat, 26 Mar 2011 14:23:41 +0000

Yazar: murat turan
Konu: 2065
G�nderim Zaman�: 26.Mart.2011 Saat 14:23

Common Table Expressions (CTEs)

sql server 2005 ile birlikte gelen bir yeniliktir
ama� gecici bir tablo sonucu tutmak ve bunu bir tabloymu� gibi geriye d�nd�rmek

�ablon:

WITH [ ( [,...n] ) ]
AS
( )

�rnek:
WITH shie (id, itemcode, itemval,ssuresikd, saklamakd, rcx)
AS
(
  SELECT id, itemcode , itemval, ssuresikd, saklamakd, (
   SELECT COUNT(id) as rcy from dbo.Klasorler AS k2
   WHERE parentId = k1.id
  ) AS rcx FROM dbo.Klasorler AS k1
  WHERE (itemcode != '99') AND (parentId IS NOT NULL) AND (itemval like @itemval)
)

-- sonu� �zerinde tekrar �artl� sorgu �al��t�r�labilir veya t�m sat�rlar geriye d�nd�r�lebilir

SELECT id, itemcode, itemval, ssuresikd, saklamakd FROM shie
WHERE (rcx = 0);

Datakent Forum : Common Table Expressions (CTEs)

Common Table Expressions (CTEs) : Common Table Expressions (CTEs) sql...