SELECT yapısı içinde Önceki ve Sonraki Kayıt

DECLARE @XML XML='<IDLIST><ID VALUE=”00000000-0000-0000-0000-000000000000″/></IDLIST>’ DECLARE @docHandle INT CREATE TABLE #tmp ( ID UNIQUEIDENTIFIER  ) EXEC sp_xml_preparedocument @docHandle OUTPUT, @XML INSERT INTO #tmp SELECT  * FROM OPENXML (@docHandle, ‘/IDLIST/ID’, 1) WITH(VALUE UNIQUEIDENTIFIER) EXEC sp_xml_removedocument @docHandle  

SELECT T2.FieldSomething, STUFF(( SELECT ‘,’ T1.Field FROM Table1 T1 WHERE T1.IDField =T2.IDField ORDER BY T1.Field FOR XML PATH(”) ), 1, 1, ”) AS FieldName FROM Table2 T2  

SELECT  CAST(CAST(0 AS BINARY) AS UNIQUEIDENTIFIER)