Home > database >  Consult a database compatibility level problem
Consult a database compatibility level problem

Time:10-06

When I was in PB development, connection is SQLserver2005, have a piece of code is written by our predecessors, I COPY to come over to use
Results the following situation:
The query is not using the ANSI outer join operator (" *="or"="*"), if the query or modify the operation, please use the stored procedure sp_dbcmptlevel compatible with the level of the current database is set to 80 or less,
Strongly recommend the use of ANSI OUTER JOIN operator (LEFT OUTER JOIN, RIGHT OUTER JOIN) rewrite the query

How to put the compatibility level is set to 80, of the following would now database has a bad influence on me???????
thank you

CodePudding user response:

Support her Lord, collection

CodePudding user response:

As if it's not that simple, ha ha.
  • Related