Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

SQL for Microsoft Dynamic NAV 2013

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    Miguel Llorca Gómez Profile Picture
    7,019 User Group Leader on at
    RE: SQL for Microsoft Dynamic NAV 2013

    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.

  • Suggested answer
    Suresh Kulla Profile Picture
    47,688 on at
    RE: SQL for Microsoft Dynamic NAV 2013

    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.

  • Suggested answer
    keoma Profile Picture
    32,727 on at
    RE: SQL for Microsoft Dynamic NAV 2013

    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

  • Raja Venkat Profile Picture
    192 on at
    RE: SQL for Microsoft Dynamic NAV 2013

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans