Database

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Thabo
-- Create date: 18.02.2011
-- Description:	TEST XML
-- =============================================
ALTER PROCEDURE [dbo].[sppassingStoredProcedue]
AS
DECLARE @x XML 
BEGIN

	SET NOCOUNT ON;
	SET @x=(SELECT PramryKeyForThisTable,AutoNumberColumn,Data1,Data2,Data3 FROM tblInsertTableForAutoNumber FOR XML AUTO,ROOT('MYROOT'))

INSERT INTO CopyOftblInserTableForAutonumber
SELECT
	R.Tab.value('@PrimaryKeyForThisTable[1]','SMALLINT)') AS PramryKeyForThisTable,
	R.Tab.value('@AutoNumberColumntext[1]','SMALLINT')AS AutoNumberColumn,
	R.Tab.value('@Data1 [1]','VARCHAR(50)') AS Data1,
	R.Tab.value('@Data2 [1]','VARCHAR(50)') AS Data2,
	R.Tab.value('@Data3 [1]','VARCHAR(50)') AS Data3
FROM @x.nodes('//MYROOT/tblInsertTableForAutoNumber')AS R(Tab)
	
	
END 

create table Test (
  id  int         not null primary key identity(1,1),
  val varchar(10) not null
);

insert into Test (val) values ('First');
insert into Test (val) values ('Second');
delete from Test;
insert into Test (val) values ('First');
insert into Test (val) values ('Second');

DECLARE @x XML 
begin   
   SET @x=(SELECT id, val 
           FROM Test 
           FOR XML AUTO ,TYPE ,ELEMENTS XSINIL,ROOT('TABLEROOT'));
        
   print convert(varchar(max), @x)

   SELECT tab.col.value('id[1]','SMALLINT') AS NewId,
          tab.col.value('val[1]','VARCHAR(10)') AS NewVal
   FROM @x.nodes('//TABLEROOT/Test')AS tab(Col);
end

set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Thabo
-- Create date: 18.02.2011
-- Description:	TEST XML
-- =============================================
CREATE PROCEDURE [dbo].[sppassingStoredProcedue]
AS
DECLARE @x XML 
BEGIN

	SET NOCOUNT ON;
	SET @x=(SELECT PramryKeyForThisTable,AutoNumberColumn,Data1,Data2,Data3 FROM tblInsertTableForAutoNumber FOR XML AUTO,ROOT('MYROOT'))

INSERT INTO CopyOftblInserTableForAutonumber 
SELECT
	R.Tab.value('@PramryKeyForThisTable [1]','SMALLINT') AS PramryKeyForThisTable,
	R.Tab.value('@AutoNumberColumn [1]','SMALLINT')AS AutoNumberColumn,
	R.Tab.value('@Data1 [1]','VARCHAR(50)') AS Data1,
	R.Tab.value('@Data2 [1]','VARCHAR(50)') AS Data2,
	R.Tab.value('@Data3 [1]','VARCHAR(50)') AS Data3
FROM @x.nodes('//MYROOT/tblInsertTableForAutoNumber')AS R(Tab)
	
	
END 

select * 
from  orders a
where a.customer = 'A'
and ( a.id in (select top(2) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       < 26
               order by b.id desc)
   or
      a.id in (select top(3) id
	       from  orders b
               where b.customer = a.customer
               and   b.id       >= 26
               order by b.id asc))

Brady Kelly wrote:

but insanely undocumented.

SELECT * FROM sysColumns WHERE id = (select id from sysObjects where name = 'myTable');