Click here to Skip to main content
15,879,239 members
Home / Discussions / Database
   

Database

 
GeneralRe: connection to database Pin
Richard MacCutchan10-Apr-12 8:33
mveRichard MacCutchan10-Apr-12 8:33 
QuestionNative paging on Sql Server Pin
SSEAR10-Apr-12 6:13
SSEAR10-Apr-12 6:13 
AnswerRe: Native paging on Sql Server Pin
jschell10-Apr-12 8:54
jschell10-Apr-12 8:54 
GeneralRe: Native paging on Sql Server Pin
SSEAR10-Apr-12 18:37
SSEAR10-Apr-12 18:37 
GeneralRe: Native paging on Sql Server Pin
jschell11-Apr-12 10:03
jschell11-Apr-12 10:03 
AnswerRe: Native paging on Sql Server Pin
Mycroft Holmes10-Apr-12 12:59
professionalMycroft Holmes10-Apr-12 12:59 
GeneralRe: Native paging on Sql Server Pin
SSEAR10-Apr-12 18:41
SSEAR10-Apr-12 18:41 
AnswerRe: Native paging on Sql Server Pin
kalaisw11-Apr-12 21:52
kalaisw11-Apr-12 21:52 
Hi,
Try below

If you want page index 1 (between 10-9 and 10)
page index 2 (between 20-9 and 20)
.
.
page index 25 (between 250-9 and 250)

SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY OBJECT_ID) AS [PageIndex],* FROM sys.objects
) AS TB1
WHERE PageIndex BETWEEN 10-9 AND 10
Questionhow to insert mathematical and chemical formula in SQL server 2005 database Pin
pankaj30869-Apr-12 23:37
pankaj30869-Apr-12 23:37 
AnswerRe: how to insert mathematical and chemical formula in SQL server 2005 database Pin
Richard MacCutchan10-Apr-12 0:17
mveRichard MacCutchan10-Apr-12 0:17 
AnswerRe: how to insert mathematical and chemical formula in SQL server 2005 database Pin
jschell10-Apr-12 8:58
jschell10-Apr-12 8:58 
GeneralRe: how to insert mathematical and chemical formula in SQL server 2005 database Pin
pankaj308610-Apr-12 16:54
pankaj308610-Apr-12 16:54 
GeneralRe: how to insert mathematical and chemical formula in SQL server 2005 database Pin
jschell11-Apr-12 10:04
jschell11-Apr-12 10:04 
QuestionAppend data within XML file using form Pin
gdmoland9-Apr-12 8:56
gdmoland9-Apr-12 8:56 
AnswerRe: Append data within XML file using form Pin
Mycroft Holmes9-Apr-12 12:42
professionalMycroft Holmes9-Apr-12 12:42 
QuestionDatabase Pin
Ngobi Arthur8-Apr-12 5:57
Ngobi Arthur8-Apr-12 5:57 
AnswerRe: Database Pin
PIEBALDconsult8-Apr-12 6:03
mvePIEBALDconsult8-Apr-12 6:03 
GeneralRe: Database Pin
gdmoland9-Apr-12 9:13
gdmoland9-Apr-12 9:13 
GeneralRe: Database Pin
PIEBALDconsult9-Apr-12 9:25
mvePIEBALDconsult9-Apr-12 9:25 
AnswerRe: Database Pin
Eddy Vluggen9-Apr-12 10:36
professionalEddy Vluggen9-Apr-12 10:36 
AnswerCant see database in SSE after importing with SSMA[solved] Pin
Richard.Berry1006-Apr-12 19:34
Richard.Berry1006-Apr-12 19:34 
QuestionGet a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 4:26
Richard.Berry1006-Apr-12 4:26 
AnswerRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 4:33
mvePIEBALDconsult6-Apr-12 4:33 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
Richard.Berry1006-Apr-12 5:04
Richard.Berry1006-Apr-12 5:04 
GeneralRe: Get a datarow with a query OLEDB - VB.net Pin
PIEBALDconsult6-Apr-12 5:11
mvePIEBALDconsult6-Apr-12 5:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.