Click here to Skip to main content
15,943,406 members
Home / Discussions / Database
   

Database

 
QuestionDSN Pin
Lek Plepi11-Mar-14 1:27
Lek Plepi11-Mar-14 1:27 
AnswerRe: DSN Pin
cdpsource11-Mar-14 2:14
cdpsource11-Mar-14 2:14 
AnswerRe: DSN Pin
Mycroft Holmes11-Mar-14 2:25
professionalMycroft Holmes11-Mar-14 2:25 
QuestionHo to avoid Not In & In clause in my query Pin
member002611-Mar-14 0:43
member002611-Mar-14 0:43 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
Bernhard Hiller11-Mar-14 1:04
Bernhard Hiller11-Mar-14 1:04 
GeneralRe: Ho to avoid Not In & In clause in my query Pin
member002611-Mar-14 18:08
member002611-Mar-14 18:08 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
thatraja11-Mar-14 2:07
professionalthatraja11-Mar-14 2:07 
AnswerRe: Ho to avoid Not In & In clause in my query Pin
GuyThiebaut11-Mar-14 3:54
professionalGuyThiebaut11-Mar-14 3:54 
SQL
select id,name
from stud s
where not exists
(
    select c.id
    from class c
    where c.id = s.id
)
and depid in
(
    select depid
    from dep
    where rid=@rid
)

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens

QuestionAdding Sales Totals from multiple tables Pin
jkirkerx9-Mar-14 10:54
professionaljkirkerx9-Mar-14 10:54 
AnswerRe: Adding Sales Totals from multiple tables Pin
Mycroft Holmes9-Mar-14 14:16
professionalMycroft Holmes9-Mar-14 14:16 
GeneralRe: Adding Sales Totals from multiple tables Pin
jkirkerx9-Mar-14 17:44
professionaljkirkerx9-Mar-14 17:44 
AnswerRe: Adding Sales Totals from multiple tables Pin
Jörgen Andersson9-Mar-14 22:01
professionalJörgen Andersson9-Mar-14 22:01 
GeneralRe: Adding Sales Totals from multiple tables Pin
jkirkerx10-Mar-14 6:26
professionaljkirkerx10-Mar-14 6:26 
GeneralRe: Adding Sales Totals from multiple tables Pin
Jörgen Andersson10-Mar-14 8:35
professionalJörgen Andersson10-Mar-14 8:35 
QuestionHow to prevent or allow a insert trigger ? Pin
ngoloi9-Mar-14 6:15
ngoloi9-Mar-14 6:15 
AnswerRe: How to prevent or allow a insert trigger ? Pin
Mycroft Holmes9-Mar-14 13:09
professionalMycroft Holmes9-Mar-14 13:09 
GeneralRe: How to prevent or allow a insert trigger ? Pin
ngoloi9-Mar-14 18:02
ngoloi9-Mar-14 18:02 
AnswerRe: How to prevent or allow a insert trigger ? Pin
GuyThiebaut9-Mar-14 22:37
professionalGuyThiebaut9-Mar-14 22:37 
GeneralRe: How to prevent or allow a insert trigger ? Pin
ngoloi10-Mar-14 4:28
ngoloi10-Mar-14 4:28 
GeneralRe: How to prevent or allow a insert trigger ? Pin
GuyThiebaut10-Mar-14 4:52
professionalGuyThiebaut10-Mar-14 4:52 
QuestionSql Server Express: Testing sql-commands Pin
Frygreen9-Mar-14 3:03
Frygreen9-Mar-14 3:03 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard MacCutchan9-Mar-14 3:33
mveRichard MacCutchan9-Mar-14 3:33 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Jörgen Andersson9-Mar-14 7:42
professionalJörgen Andersson9-Mar-14 7:42 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Mycroft Holmes9-Mar-14 13:05
professionalMycroft Holmes9-Mar-14 13:05 
AnswerRe: Sql Server Express: Testing sql-commands Pin
Richard Deeming10-Mar-14 2:49
mveRichard Deeming10-Mar-14 2:49 

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.