Click here to Skip to main content
15,867,835 members
Home / Discussions / Database
   

Database

 
AnswerRe: database mirroring / database replication. Pin
Eddy Vluggen31-Jul-13 9:05
professionalEddy Vluggen31-Jul-13 9:05 
QuestionHow to link pdf file in iframe ? Pin
caulsonchua29-Jul-13 15:23
caulsonchua29-Jul-13 15:23 
AnswerRe: How to link pdf file in iframe ? Pin
Mycroft Holmes29-Jul-13 16:27
professionalMycroft Holmes29-Jul-13 16:27 
QuestionReturn Results of a Join Using Stored Proc Pin
ASPnoob27-Jul-13 20:23
ASPnoob27-Jul-13 20:23 
AnswerRe: Return Results of a Join Using Stored Proc Pin
Boipelo27-Jul-13 22:07
Boipelo27-Jul-13 22:07 
AnswerRe: Return Results of a Join Using Stored Proc Pin
Mycroft Holmes27-Jul-13 22:38
professionalMycroft Holmes27-Jul-13 22:38 
AnswerRe: Return Results of a Join Using Stored Proc Pin
jschell28-Jul-13 10:31
jschell28-Jul-13 10:31 
QuestionRight outer join with no ON Pin
vkEE26-Jul-13 7:11
vkEE26-Jul-13 7:11 
Hello All!

I am trying to debug someone else's stored procedure.

I see a RIGHT OUTER JOIN clause with no ON reference.

It goes in this form:

select
 *
from
 a inner join b on a.id=b.id
 inner join c on a.id=c.id
 right outer join e
 inner join f on e.id = f.id


Strange part it is does not complain of syntax error.

When I try to re-write the same sql, it straight out errors out!

I don't know how the previous developer was able to compile the code!!

Thanks!!!
GeneralRe: Right outer join with no ON Pin
PIEBALDconsult26-Jul-13 16:18
mvePIEBALDconsult26-Jul-13 16:18 
AnswerRe: Right outer join with no ON Pin
Mycroft Holmes26-Jul-13 17:33
professionalMycroft Holmes26-Jul-13 17:33 
GeneralRe: Right outer join with no ON Pin
PIEBALDconsult26-Jul-13 19:01
mvePIEBALDconsult26-Jul-13 19:01 
QuestionChanging Server names Dynamically in Stored Procedure Pin
indian14325-Jul-13 6:42
indian14325-Jul-13 6:42 
AnswerRe: Changing Server names Dynamically in Stored Procedure Pin
Richard Deeming25-Jul-13 7:26
mveRichard Deeming25-Jul-13 7:26 
GeneralRe: Changing Server names Dynamically in Stored Procedure Pin
indian14325-Jul-13 8:59
indian14325-Jul-13 8:59 
GeneralRe: Changing Server names Dynamically in Stored Procedure Pin
Richard Deeming25-Jul-13 9:07
mveRichard Deeming25-Jul-13 9:07 
GeneralRe: Changing Server names Dynamically in Stored Procedure Pin
indian14325-Jul-13 9:20
indian14325-Jul-13 9:20 
GeneralRe: Changing Server names Dynamically in Stored Procedure Pin
GuyThiebaut26-Jul-13 2:03
professionalGuyThiebaut26-Jul-13 2:03 
QuestionSSIS package question Pin
vkEE24-Jul-13 9:48
vkEE24-Jul-13 9:48 
AnswerRe: SSIS package question Pin
PIEBALDconsult25-Jul-13 3:42
mvePIEBALDconsult25-Jul-13 3:42 
GeneralRe: SSIS package question Pin
vkEE25-Jul-13 3:46
vkEE25-Jul-13 3:46 
QuestionUpdate trigger. Pin
Septimus Hedgehog24-Jul-13 4:57
Septimus Hedgehog24-Jul-13 4:57 
AnswerRe: Update trigger. Pin
Richard Deeming24-Jul-13 8:05
mveRichard Deeming24-Jul-13 8:05 
GeneralRe: Update trigger. Pin
Septimus Hedgehog24-Jul-13 11:33
Septimus Hedgehog24-Jul-13 11:33 
GeneralRe: Update trigger. Pin
Mycroft Holmes24-Jul-13 12:47
professionalMycroft Holmes24-Jul-13 12:47 
GeneralRe: Update trigger. Pin
Septimus Hedgehog24-Jul-13 20:15
Septimus Hedgehog24-Jul-13 20:15 

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.