Skip to Content
0
Former Member
Jul 13, 2015 at 06:45 AM

migration from sql8.0 compatibility to ansi standard: any tips?

20 Views

Hi,

I've this 10+ year old in house application with over 2000 lines of sql script containing *=

(ie:

SELECT COUNT(*)

FROM tblcases b,tblinvoice a

WHERE ( b.jobreferenceno *= a.jobreferenceno )

to be updated to

SELECT COUNT(*)

FROM tblcases AS b LEFT OUTER JOIN

tblinvoice AS a ON b.jobreferenceno = a.jobreferenceno

---

so I've been converting the various sql statements via searching for *= and =*

do I take it when I no longer have any more *=/=*, I'm pretty fine to go? I also think I do not really have to convert anything that is a graphic view datawindow right?

ie:

statements such as

SELECT COUNT(*)

FROM tblcases b,tblinvoice a

WHERE ( b.jobreferenceno = a.jobreferenceno )

would be left unaltered and I don't really need to convert to

SELECT COUNT(*)

FROM tblcases AS b INNER JOIN

tblinvoice AS a ON b.jobreferenceno = a.jobreferenceno

any other tips?