Click here to Skip to main content
15,920,596 members
Home / Discussions / Database
   

Database

 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 14:51
professionalMycroft Holmes12-Mar-15 14:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 22:12
delgaillo12-Mar-15 22:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 22:14
professionalMycroft Holmes12-Mar-15 22:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 0:17
delgaillo28-Sep-15 0:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 14:25
Member 115083508-Mar-15 14:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:33
professionalRichard Andrew x648-Mar-15 15:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:42
Member 115083508-Mar-15 15:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:48
professionalRichard Andrew x648-Mar-15 15:48 
You could try a subquery:

SQL
SELECT HotelNo, RoomNo FROM Room WHERE RoomNo NOT IN (SELECT RoomNo FROM Reservation) ORDER BY HotelNo, RoomNo




The difficult we do right away...
...the impossible takes slightly longer.

GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:59
Member 115083508-Mar-15 15:59 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 16:21
professionalRichard Andrew x648-Mar-15 16:21 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:25
Member 115083508-Mar-15 16:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 16:56
Member 115083508-Mar-15 16:56 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:18
Member 115083508-Mar-15 17:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 22:07
Chris Quinn8-Mar-15 22:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 6:51
Abdulnazark9-Mar-15 6:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:01
Member 115083509-Mar-15 17:01 
GeneralRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 21:06
Abdulnazark9-Mar-15 21:06 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 16:48
Member 115083509-Mar-15 16:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:59
Member 115083509-Mar-15 17:59 
QuestionVB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE28-Feb-15 22:01
KipkoechE28-Feb-15 22:01 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
manchanx1-Mar-15 1:01
professionalmanchanx1-Mar-15 1:01 
GeneralRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE3-Mar-15 19:48
KipkoechE3-Mar-15 19:48 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
Mycroft Holmes1-Mar-15 13:54
professionalMycroft Holmes1-Mar-15 13:54 
GeneralHow to increase SQL Query Performance for the Oracle Database Pin
Blog euth26-Feb-15 23:08
Blog euth26-Feb-15 23:08 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Jörgen Andersson26-Feb-15 23:37
professionalJörgen Andersson26-Feb-15 23:37 

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.