• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

updating data to SQL 2012

I backed up a SQL 2000 database and restored in SQL 2005, then restored the SQL 2005 backup to SQL 2012.

The Stored Procedures need some updating, one of the errors is regarding '*='

Does anyone know what this expression has been replaced with?

Thank you
0
urthrilled
Asked:
urthrilled
  • 3
  • 2
1 Solution
 
QPRCommented:
Can you show some code where you are using "*=" please
0
 
Scott PletcherSenior DBACommented:
LEFT OUTER JOIN.
0
 
Scott PletcherSenior DBACommented:
For example, if you see something like:

SELECT t1.*, t2.name, ...
FROM dbo.table1 t1, dbo.table2 t2
WHERE
    t1.id *= t2.id

The modern equivalent is:

SELECT t1.*, t2.name, ...
FROM dbo.table1 t1
LEFT OUTER JOIN dbo.table2 t2 ON
    t1.id = t2.id
0
 
QPRCommented:
Ahhh been a while!
No longer supported http://msdn.microsoft.com/en-us/library/ms144262.aspx

So as Scott posted above, you need to change them to the modern equivalent
0
 
Scott PletcherSenior DBACommented:
But you have to be extremely careful when testing the re-coded queries, because
LEFT OUTER JOIN can behave differently from *=, particularly relating to conditions in the WHERE clause on the right-hand table (table2 in my example above).

If you need further help with that, let us know.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now