Hanya sekedar menambahkan untuk syntax sql
select n skip n di mssql server 2000, koq saya nggak ketemu ya ?
atau memang nggak ada ? :P
but saya coba buat SP di mssql2000 sbb:
use pubs
go
create proc SP_Select_Skip(@NamaTable as varchar(255),@SFieldKey as
varchar(255),@NFirst as bigint, @NSkip as bigInt)
as
declare @Ssql as varchar(8000)
set @ssql='select top '+cast(@nfirst as varchar(20))+' * from '[EMAIL PROTECTED]
+' where '[EMAIL PROTECTED]' not in ( select top '+cast(@nfirst as
varchar(20))
+' '[EMAIL PROTECTED]
+' from '[EMAIL PROTECTED] ' order by '[EMAIL PROTECTED]' ) order by '[EMAIL
PROTECTED]
exec( @ssql)
go
sp_select_skip 'employee','emp_id',10,10
sp tersebut akan menghasilkan data ke 11 s.d 20 berdasarkan urutan field
emp_id
Mudah-mudahan bisa ikut membantu yaa.. :)
BR,
Ahmad Yadi
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Upgrade to 128-Bit SSL Security!
http://us.click.yahoo.com/p7cEmB/s7qGAA/yigFAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
