SQL for Microsoft Dynamic NAV 2013

(0) Share

Report

Posted on by Community Member

Microsoft SQL server 2012 using for many purpose I am not expert for this I want to learn SQL Server for Dynamic NAV 2013 because we recently installed in our organization from where I can learn the parts of SQL which is necessary for running this system.??????

best wishes

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Raja Venkat 192 on at

Like (0)

Report

Do you mean Sql Statements For Inserting Retrieving ..1st and Foremost Basic Knowledge is required Refer to these links for Basic Statements

mariadb.com/.../basic-sql-statements

www.itl.nist.gov/.../sql_examples.htm

Was this reply helpful? Yes No
Suggested answer

keoma 32,729 on at

Like (0)

Report

in general you do not need very much knowledge about sql server when using dynamics nav. but you should acquire some basics.

for nav versus sql follow

msdn.microsoft.com/.../dd568708(v=nav.70).aspx

msdn.microsoft.com/.../dd301267(v=nav.70).aspx

sql basics

msdn.microsoft.com/.../ms166547.aspx

technet.microsoft.com/.../bb264565(v=sql.90).aspx

www.w3schools.com/.../sql_intro.asp

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,245 Super User 2025 Season 2 on at

Like (0)

Report

For you to run the system with Navision, you don't need to expert in SQL, you just need to some basics of SQL and also how to backup/restore and create logins or setup security in SQL.

You can learn some basic language skills in the below link

www.sqlcourse.com/intro.html

Some videos on youtube about backup and login

www.youtube.com/watch

www.youtube.com/watch

And so many other videos are available on YouTube.

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (0)

Report

Hi Nematullah! In response to your question, you only should indicate to NAV when you install it the SQL instance name, and the database name. Thats all! You only need the engine, other SQL stuff is not mandatory. You can use a default SQL installation.

Was this reply helpful? Yes No