Click here to Skip to main content
15,300,205 members
Home / Discussions / Database
   

Database

 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Richard.Berry10012-May-14 7:55
MemberRichard.Berry10012-May-14 7:55 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Eddy Vluggen12-May-14 8:49
professionalEddy Vluggen12-May-14 8:49 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Corporal Agarn12-May-14 9:45
professionalCorporal Agarn12-May-14 9:45 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
jschell12-May-14 10:31
Memberjschell12-May-14 10:31 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
Mycroft Holmes12-May-14 22:25
professionalMycroft Holmes12-May-14 22:25 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens13-May-14 2:18
professionalNico Haegens13-May-14 2:18 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Mycroft Holmes13-May-14 12:52
professionalMycroft Holmes13-May-14 12:52 
QuestionDatabase SQL Pin
Syafiqah Zahirah10-May-14 4:47
MemberSyafiqah Zahirah10-May-14 4:47 
Hello..i have a question about SQL Statements

In my database, i have a data about datetime. The example as shown below:

2014-03-25 17:57:34.177

2014-03-25 18:01:25.280

2014-03-25 18:01:28.240

2014-03-25 18:01:33.207

This is just a few example but in my database the data is more than this.So how if i want to display the data from 30 minutes ago? what is the sql statement should I use?
AnswerRe: Database SQL Pin
Peter Leow10-May-14 5:24
professionalPeter Leow10-May-14 5:24 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 3:43
MemberSyafiqah Zahirah11-May-14 3:43 
AnswerRe: Database SQL Pin
Peter Leow11-May-14 4:13
professionalPeter Leow11-May-14 4:13 
GeneralRe: Database SQL Pin
Syafiqah Zahirah11-May-14 4:45
MemberSyafiqah Zahirah11-May-14 4:45 
GeneralRe: Database SQL Pin
Syafiqah Zahirah15-May-14 6:50
MemberSyafiqah Zahirah15-May-14 6:50 
GeneralRe: Database SQL Pin
Peter Leow15-May-14 14:47
professionalPeter Leow15-May-14 14:47 
QuestionArithmetic rounding Pin
Richard.Berry1009-May-14 11:04
MemberRichard.Berry1009-May-14 11:04 
AnswerRe: Arithmetic rounding Pin
Richard Andrew x649-May-14 12:26
professionalRichard Andrew x649-May-14 12:26 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 20:58
MemberRichard.Berry1009-May-14 20:58 
AnswerRe: Arithmetic rounding Pin
Andrius Leonavicius9-May-14 15:02
professionalAndrius Leonavicius9-May-14 15:02 
GeneralRe: Arithmetic rounding Pin
Richard.Berry1009-May-14 20:45
MemberRichard.Berry1009-May-14 20:45 
GeneralRe: Arithmetic rounding Pin
Andrius Leonavicius10-May-14 4:28
professionalAndrius Leonavicius10-May-14 4:28 
QuestionFetch records efficiently Pin
avi_dadi20029-May-14 9:15
Memberavi_dadi20029-May-14 9:15 
AnswerRe: Fetch records efficiently Pin
Richard Andrew x649-May-14 10:30
professionalRichard Andrew x649-May-14 10:30 
AnswerRe: Fetch records efficiently Pin
Richard MacCutchan9-May-14 21:49
mveRichard MacCutchan9-May-14 21:49 
QuestionNeed to fetch from two data sources Pin
avi_dadi20029-May-14 9:11
Memberavi_dadi20029-May-14 9:11 
AnswerRe: Need to fetch from two data sources Pin
Richard.Berry1009-May-14 21:40
MemberRichard.Berry1009-May-14 21:40 

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.