Access Query with SQL Server Query "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <microbrain[ at ]vsnl.com> 12/12/2008 11:45:38 AM Dear Sir, Can any one tell me where I can find the list of commands and function of JET SQL not supported in SQL Server 2005 Query. Sanjay Shah

Re: Access Query with SQL Server Query Stefan Hoffmann <ste5an[ at ]ste5an.de> 12/13/2008 11:59:20 AM hi Sanjay, SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. wrote: [Quoted Text] > Can any one tell me where I can find the list of commands and function of > JET SQL not supported in SQL Server 2005 Query. http://msdn.microsoft.com/en-us/library/bb208890.aspx And the SQL Server BOLs, of course: http://msdn.microsoft.com/en-us/library/ms130214.aspx http://msdn.microsoft.com/en-us/library/ms181080.aspx mfG --> stefan <--

Re: Access Query with SQL Server Query "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <microbrain[ at ]vsnl.com> 12/18/2008 2:08:06 PM Hi Stefan, Thanks for your reply with link. I had gone through all link and it doesn't contains my requirement that JET SQL command not supported in MS SQL. Please note I had developed application using Visual Basic 6 & Access 2000. It works fine in Single as well as multi user environment. In my access database I keep only tables & it's relations. All the required query I am running through application. Now I want a list of command or function of JET SQL not supported in MS SQL Server 2005 like IIF(<Condition>, <True Expression>, <False Expression>) which I have to use in MS SQL as CASE WHEN <Condition> THEN <True Expression> ELSE <False Expression> END CASE So I can easily change all queries. Please help me. Sanjay Shah "Stefan Hoffmann" <ste5an[ at ]ste5an.de> wrote in message news:%23mSJBpRXJHA.5108[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > hi Sanjay, > > SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD. wrote: >> Can any one tell me where I can find the list of commands and function of >> JET SQL not supported in SQL Server 2005 Query. > http://msdn.microsoft.com/en-us/library/bb208890.aspx > > And the SQL Server BOLs, of course: > > http://msdn.microsoft.com/en-us/library/ms130214.aspx > http://msdn.microsoft.com/en-us/library/ms181080.aspx > > > mfG > --> stefan <-- >