Database

tonyalex wrote:

What i meant is the DAL Source Code that is given by the microsoft for all its .net language.........

tonyalex wrote:

yes, microsoft is providing code for the data access layer for the our custom application,think some thing like SQLHELPER

indian143 wrote:

Can anybody please tell me in SQL Server how should I get the records with their row numbers in a table.

<br />
CREATE TRIGGER dbo.trg_Count <br />
   ON  dbo._TEST<br />
   AFTER INSERT, DELETE<br />
AS <br />
BEGIN<br />
	<br />
	SET NOCOUNT ON;<br />
	DECLARE @PKEY UNIQUEIDENTIFIER<br />
	DECLARE @I BIGINT<br />
	<br />
	IF ((SELECT trigger_nestlevel()) = 1)<br />
	BEGIN<br />
		DECLARE TRG_TEST_CUR CURSOR FOR<br />
		SELECT [GUID] FROM _TEST<br />
<br />
		OPEN TRG_TEST_CUR<br />
		FETCH NEXT FROM TRG_TEST_CUR<br />
		INTO @PKEY<br />
		<br />
		SET @I = 1<br />
<br />
		WHILE @@FETCH_STATUS = 0<br />
		BEGIN<br />
			UPDATE _TEST SET ID = @I WHERE [GUID] = @PKEY<br />
			SET @I = @I + 1<br />
			FETCH NEXT FROM TRG_TEST_CUR<br />
			INTO @PKEY<br />
		END<br />
		CLOSE TRG_TEST_CUR<br />
		DEALLOCATE TRG_TEST_CUR<br />
	END<br />
END<br />
GO<br />

Select top 10 * from TALE_NAME
where ID not in
(Select top 20 ID from TALE_NAME order by ID )
order by ID

With ctp as 
(
Select row_number() over (order by ID) a, * from TABLE_NAME
)
Select * from ctp
where a between 21 and 30
order by a