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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Access

Author  Topic 

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-09-09 : 08:47:03
Hi,
I am in the process of converting alot of Access sql (Including complicated IIF) into sql server sql.
Is there a website which does this conversion?
Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-09-09 : 08:53:08
IIF of Access is equla to CASE WHEN expression of SQL Server

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

arkiboys
Master Smack Fu Yak Hacker

1433 Posts

Posted - 2009-09-09 : 08:58:03
Yes, I understand that but my question is if there is a website which you give it the access sql and it then returns the equivalent sql in sql server format.
Is there such a site?
Thanks
Go to Top of Page

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-09-09 : 09:10:29
Sqlways tool will be help full for u!

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page
   

- Advertisement -