SQL Conversion

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

HI, is there an easy way to convert T-SQL to Jet-SQL? Perhaps some 3rd party
utility

Thanks
 
There aren't really that many differences. What specifically are you having
problems with?
 
Hi Doug, thanks for replying.

I have a very long sproc with unions and many joins, I'd like to insert the
script into a regular jet query, but I'm having syntax problems....likely
brackets. I do know that 'Left Outer Join' is not valid in Jet.
It would be nice if you could just transform SQL from one side (T-SQL) to
the other (Jet) and it would work.

Any thoughts.
Henry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conversion from Jet to SQL 3
How to Convert EML to PST in 2025? 2
Which is the best MBOX Converter Tool different formats conversion? 4
Convert a Number field to Autonumber? 15
What are the steps to fix damaged MDF files in SQL Server? 0
SqlParameter to SQL declare representation 4
Converting Microsoft Access SQL to Microsoft SQL Server 2005 5
SQL upsize 2 databases 2

Back
Top