Tagged: Development

Stored Procedures and Navision

If you are executing a specific SQL query very often, it would be usefully to have it as Stored Procedure on the SQL Server.

Stored Procedures is a collection of SQL statements.

There are 2 ways to create a store procedure:

  1. In the SQL Server Management Studio – you can right click on Stored Procedures and chose to create a new Stored Procedure. It will then create a template for you, which you just have to fill out and execute
  2. The second way is to build a script by yourself

Read more »

ADO in Navision


With ADO you can execute SQL Scripts and Stored Procedures from Navision.

To use ADO in Navision, you have to use the automation “Microsoft ActiveX Data Objects 2.8 Library”

Lets take a closer on how to make a SQL connection and perform a SQL Query in Navision.

Read more »


For test purpose I did a little test in C#, where I did use ADO.NET to make a connection to my SQL Server.

The common way to access a database is to do the following:

  1. Open a connection to the Database
  2. Perform the Query using a recordset for the returned data
  3. Extract Data needed and close the recordset
  4. Close the connection

Lets take a close look on how to do it in C# ADO.NET

Read more »


If you have to optimize a lot of tables and indexes. You could create a SQL script, which then could be scheduled.

Read more »

Some usefull SQL Commands

If you are a SQL Server administrator or just working with it, these commands would be use full for you.


Modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.

Read more »