Click here to Skip to main content
15,921,716 members
Home / Discussions / Database
   

Database

 
QuestionAccess 2000-Jet/VB6 - SQL Query (HELP- SQL Gurus) Pin
tintinchasm19-Nov-06 22:34
tintinchasm19-Nov-06 22:34 
AnswerRe: Access 2000-Jet/VB6 - SQL Query (HELP- SQL Gurus) Pin
rah_sin20-Nov-06 0:02
professionalrah_sin20-Nov-06 0:02 
GeneralRe: Access 2000-Jet/VB6 - SQL Query (HELP- SQL Gurus) Pin
tintinchasm20-Nov-06 6:11
tintinchasm20-Nov-06 6:11 
QuestionENUM Pin
thathvamsi19-Nov-06 21:35
thathvamsi19-Nov-06 21:35 
AnswerRe: ENUM Pin
Leah_Garrett22-Nov-06 13:20
Leah_Garrett22-Nov-06 13:20 
QuestionDB Owner - Diagrams Pin
MatthysDT19-Nov-06 19:59
MatthysDT19-Nov-06 19:59 
AnswerRe: DB Owner - Diagrams Pin
Leah_Garrett22-Nov-06 13:24
Leah_Garrett22-Nov-06 13:24 
QuestionSQL error Pin
walalawll19-Nov-06 15:31
walalawll19-Nov-06 15:31 
Hi all,

I have a sql statement that occur error when I run in sql server 2005....

"The query uses non-ANSI outer join operators ("*=" or "=*"). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future versions of SQL Server, non-ANSI join operators will not be supported even in backward-compatibility modes."


update
TMP_TABLE_1
set
CLASS_NO = coalesce(B.CLASS_NO , B.STUDENT_NO)
from TMP_TABLE_1 A,
TMP_TABLE_2 B
where
A.CLASS_NO *= B.STUDENT_NO
and A.REQUEST_ID = @requestID


But How can I change the sql to Right outer join or left outer join.

Please kindly help.

Thanks
AnswerRe: SQL error Pin
Mike Dimmick20-Nov-06 0:52
Mike Dimmick20-Nov-06 0:52 
GeneralRe: SQL error Pin
walalawll29-Nov-06 21:22
walalawll29-Nov-06 21:22 
QuestionTimeout exception error Pin
Lior S19-Nov-06 4:04
Lior S19-Nov-06 4:04 
AnswerRe: Timeout exception error Pin
Colin Angus Mackay19-Nov-06 4:58
Colin Angus Mackay19-Nov-06 4:58 
AnswerRe: Timeout exception error Pin
ThaScorpion19-Nov-06 13:44
ThaScorpion19-Nov-06 13:44 
QuestionDatatype mismatch...column type date/time Pin
Skcheng18-Nov-06 17:09
Skcheng18-Nov-06 17:09 
AnswerRe: Datatype mismatch...column type date/time Pin
Rob Graham19-Nov-06 6:19
Rob Graham19-Nov-06 6:19 
GeneralRe: Datatype mismatch...column type date/time [modified] Pin
Skcheng19-Nov-06 8:57
Skcheng19-Nov-06 8:57 
GeneralRe: Datatype mismatch...column type date/time Pin
Skcheng19-Nov-06 11:06
Skcheng19-Nov-06 11:06 
AnswerRe: Datatype mismatch...column type date/time Pin
Scott Holt20-Nov-06 16:17
Scott Holt20-Nov-06 16:17 
GeneralRe: Datatype mismatch...column type date/time Pin
Skcheng20-Nov-06 16:29
Skcheng20-Nov-06 16:29 
QuestionSQL trigger , Pin
drequinox18-Nov-06 4:48
drequinox18-Nov-06 4:48 
QuestionExtracting date part in SQL server Pin
ThaScorpion17-Nov-06 14:41
ThaScorpion17-Nov-06 14:41 
AnswerRe: Extracting date part in SQL server Pin
Janani Divya17-Nov-06 18:00
Janani Divya17-Nov-06 18:00 
GeneralRe: Extracting date part in SQL server Pin
ThaScorpion18-Nov-06 14:05
ThaScorpion18-Nov-06 14:05 
GeneralRe: Extracting date part in SQL server Pin
indianet19-Nov-06 13:11
indianet19-Nov-06 13:11 
GeneralRe: Extracting date part in SQL server Pin
ThaScorpion19-Nov-06 13:40
ThaScorpion19-Nov-06 13: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.