DIfference between Navision DB and SQL Server DB

I am new to Navision application.Can you please explain the difference between N开发者_如何学编程avision DB and Sql Server DB?

That completely depends on how you have Navision installed. See the entry on Wikipedia to see what I mean. It can be installed with SQL Server, or their native database server (referred to as 'Classic'). A google search for Classic Navision Database should get you well along in your research.

If you want to be able to use sql syntax for database queries, then you need to install the sql server database. The native database does not support sql.

Navision uses MySQL standard database, not just SQL. You should be able to see it depending on the tier composition you have on your NAV installation.