skip to main
|
skip to sidebar
RAVURI PRADEEP
Saturday, April 3, 2010
n th record using sqlserver
declare sc cursor static for select * from system1.dbo.sys_params
declare @n int
set @n=21
open sc
while @n<25
begin
fetch absolute @n from sc
set @N=@N +1
end
close sc
deallocate sc
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
►
2016
(2)
►
February
(2)
►
2014
(28)
►
November
(14)
►
October
(2)
►
September
(11)
►
August
(1)
►
2011
(1)
►
September
(1)
▼
2010
(56)
►
May
(17)
▼
April
(15)
oops
SQL 2005 Strings
Constructor vs Static Constructor
RETRIEVES CURRENT DEFAULT PRINTER AND SET DEFAULT ...
OperationContract with required parameters(WITH ot...
OperationContract with required parameters
DIFFERENCE ServiceContract & DATACONTRACT
MULTIPLE INTERFACES HAVING SAME METHOD NAME HOW TO...
links
How to show number of online users / visitors for ...
Assembly Redirection Doesn't work in web.config (A...
Find Nth maximum AND minimum value(SALARY) in SQL ...
n th record using sqlserver
RANDOM NUMBER SELECTION _USING SQL SERVER 2005 CHE...
SQL - SELECT TOP n or SELECT TOP Random n Rows Fro...
►
March
(13)
►
February
(6)
►
January
(5)
About Me
PRADEEP
View my complete profile
No comments:
Post a Comment