Click here to Skip to main content
15,565,474 members
Home / Discussions / Database
   

Database

 
GeneralRe: SSE 2008 R2 Backup Strategy Pin
Richard.Berry1001-May-13 1:10
Richard.Berry1001-May-13 1:10 
QuestionGeneric column mapping Pin
Ravikiran72p30-Apr-13 2:57
Ravikiran72p30-Apr-13 2:57 
AnswerRe: Generic column mapping Pin
Eddy Vluggen30-Apr-13 10:49
professionalEddy Vluggen30-Apr-13 10:49 
AnswerRe: Generic column mapping Pin
Mycroft Holmes30-Apr-13 14:56
professionalMycroft Holmes30-Apr-13 14:56 
AnswerRe: Generic column mapping Pin
GuyThiebaut30-Apr-13 22:49
professionalGuyThiebaut30-Apr-13 22:49 
AnswerRe: Generic column mapping Pin
jschell1-May-13 9:34
jschell1-May-13 9:34 
QuestionMariaDB on Linux Pin
mbadi27-Apr-13 11:57
mbadi27-Apr-13 11:57 
QuestionError on SQL server join Pin
DeveloperLife201526-Apr-13 14:12
DeveloperLife201526-Apr-13 14:12 
Hi All,

I am trying to run this query on my database and I am getting an error Incorrect syntax near the keyword 'JOIN'.

USE IVRCallCenterTest
Go
SELECT *
FROM dbo.OutputPromptItem WHERE SegmentId=7198
JOIN dbo.OutputPrompt
ON dbo.OutputPromptItem.PromptId=dbo.OutputPrompt.PromptID
Go

what is wrong with my code ?

Thanks in advance
AnswerRe: Error on SQL server join Pin
s_magus26-Apr-13 18:41
s_magus26-Apr-13 18:41 
AnswerRe: Error on SQL server join Pin
AANIL DHAKAD8-May-13 20:17
AANIL DHAKAD8-May-13 20:17 
QuestionSQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC26-Apr-13 13:37
PrissySC26-Apr-13 13:37 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes26-Apr-13 14:01
professionalMycroft Holmes26-Apr-13 14:01 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC27-Apr-13 2:39
PrissySC27-Apr-13 2:39 
AnswerRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
jschell27-Apr-13 12:32
jschell27-Apr-13 12:32 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
PrissySC28-Apr-13 2:41
PrissySC28-Apr-13 2:41 
GeneralRe: SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc. Pin
Mycroft Holmes28-Apr-13 13:49
professionalMycroft Holmes28-Apr-13 13:49 
AnswerAttached not seen over network still - will try ID values but .... Pin
PrissySC7-May-13 8:07
PrissySC7-May-13 8:07 
QuestionHow do I get the SSRS Report Mgr to work with a custom security extension? Pin
brandon schave23-Apr-13 7:31
brandon schave23-Apr-13 7:31 
QuestionTrouble restoring a mysql database Pin
savedlema22-Apr-13 8:21
savedlema22-Apr-13 8:21 
AnswerRe: Trouble restoring a mysql database Pin
Bernhard Hiller22-Apr-13 22:33
Bernhard Hiller22-Apr-13 22:33 
GeneralRe: Trouble restoring a mysql database Pin
savedlema2-May-13 0:44
savedlema2-May-13 0:44 
QuestionBack up database Error Pin
sara-setare20-Apr-13 22:37
sara-setare20-Apr-13 22:37 
AnswerRe: Back up database Error Pin
Mycroft Holmes21-Apr-13 1:48
professionalMycroft Holmes21-Apr-13 1:48 
GeneralRe: Back up database Error Pin
sara-setare21-Apr-13 3:41
sara-setare21-Apr-13 3:41 
AnswerRe: Back up database Error Pin
Eddy Vluggen21-Apr-13 9:45
professionalEddy Vluggen21-Apr-13 9:45 

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.