Click here to Skip to main content
14,364,354 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
adminChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
adminChris Maunder10-Nov-05 17:30 
QuestionSQL Server How to add and update element in xml data in table based on match found after search using xquery Pin
Mou_kol16-Nov-19 9:20
memberMou_kol16-Nov-19 9:20 
QuestionPivoting in SQL Pin
Anandkumar Prajapati13-Nov-19 0:50
professionalAnandkumar Prajapati13-Nov-19 0:50 
AnswerRe: Pivoting in SQL Pin
Richard Deeming13-Nov-19 3:17
mveRichard Deeming13-Nov-19 3:17 
GeneralRe: Pivoting in SQL Pin
#realJSOP15-Nov-19 1:18
mve#realJSOP15-Nov-19 1:18 
QuestionHow to think in MongoDB/Mongoose ?! Pin
AlexanderKolarov7-Nov-19 12:33
memberAlexanderKolarov7-Nov-19 12:33 
QuestionMessage Closed Pin
26-Oct-19 11:08
memberMember 1463562026-Oct-19 11:08 
QuestionMessage Closed Pin
26-Oct-19 11:08
memberMember 1463562026-Oct-19 11:08 
Questiondatabase ER diagrime Pin
Member 1463562026-Oct-19 5:01
memberMember 1463562026-Oct-19 5:01 
AnswerRe: database ER diagrime Pin
OriginalGriff26-Oct-19 5:02
protectorOriginalGriff26-Oct-19 5:02 
QuestionRe: database ER diagrime Pin
Member 1463562026-Oct-19 5:14
memberMember 1463562026-Oct-19 5:14 
AnswerRe: database ER diagrime Pin
Richard MacCutchan26-Oct-19 5:18
protectorRichard MacCutchan26-Oct-19 5:18 
AnswerRe: database ER diagrime Pin
Victor Nijegorodov26-Oct-19 6:21
memberVictor Nijegorodov26-Oct-19 6:21 
AnswerRe: database ER diagrime Pin
Mycroft Holmes26-Oct-19 14:05
memberMycroft Holmes26-Oct-19 14:05 
GeneralRe: database ER diagrime Pin
Richard MacCutchan26-Oct-19 22:46
protectorRichard MacCutchan26-Oct-19 22:46 
QuestionFetch data Pin
Member 1463481125-Oct-19 3:34
memberMember 1463481125-Oct-19 3:34 
AnswerRe: Fetch data Pin
Richard Deeming25-Oct-19 3:58
mveRichard Deeming25-Oct-19 3:58 
QuestionRe: Fetch data Pin
ZurdoDev25-Oct-19 5:22
professionalZurdoDev25-Oct-19 5:22 
Questionc# MongoDB Driver, find all products that contain a single brand name, and Group Distinct all category names, then get those categories. Pin
jkirkerx22-Oct-19 11:25
professionaljkirkerx22-Oct-19 11:25 
AnswerRe: c# MongoDB Driver, find all products that contain a single brand name, and Group Distinct all category names, then get those categories. Pin
jkirkerx22-Oct-19 11:41
professionaljkirkerx22-Oct-19 11:41 
QuestionHow do you separate in pages database results? Pin
Joan M21-Oct-19 11:00
professionalJoan M21-Oct-19 11:00 
Hi,

Working in a time tracking program, I've thought of separating results in pages.

I think of making a specific SQL query to count the amount of total registers with the applied filters, then call the another SQL query with LIMIT clause to be able to define from which record I want to start showing the results and the amount of results.

Is there any better way to do it?

Thank you in advance!
AnswerRe: How do you separate in pages database results? Pin
David Mujica23-Oct-19 3:48
memberDavid Mujica23-Oct-19 3:48 
QuestionI have a column and i need to find in which table this column exists throughout whole DB Pin
Anandkumar Prajapati8-Oct-19 20:29
professionalAnandkumar Prajapati8-Oct-19 20:29 
AnswerRe: I have a column and i need to find in which table this column exists throughout whole DB Pin
Victor Nijegorodov8-Oct-19 21:46
memberVictor Nijegorodov8-Oct-19 21:46 

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.