Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-11 : 09:56:14
|
| Luis writes "I'm looking for a function or library (C++, or VB) to convert a JET SQL Statement to SQL Server.Ex:Jet (Access):SELECT Choose (T1.SurceType, T1.Name, T2.Name) FROM Table1 T1, Table2 T2SQLServer:SELECT Case (T1.SurceType WHEN 1 THEN T1.Name WHEN 2 THEN T2.Name) FROMTable1 T1, Table2 T2I'll appreciate your help." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-06-13 : 07:38:08
|
| I don't know of one, and in any case, it wouldn't be worth using. I know you probably won't believe me, but I've spent far more time cleaning up the mess made by code translators than I had spent starting from scratch. These were not Access SQL to T-SQL converters, but there's probably even less hope for them.The best way to learn T-SQL is to write it, from scratch. Trying to convert Access SQL to T-SQL will leave you with poor T-SQL. |
 |
|
|
|
|
|
Jet to SQLServer SQL syntax converter