This blog is intended to see how Microsoft Dynamics NAV (here onwards NAV) can be connected to external databases. External databases here mean Microsoft SQL Server, CRM, Exchange* or Microsoft Graph*. We will focus on Microsoft SQL Server (non-NAV database).
Manish Prasad Kutar | NAV
, Microsoft SQL Server
, Microsoft Dynamics NAV
, NAV 2016
, NAV 2017
, Integration | SQL Server
, Microsoft Dynamics NAV
, MS Dynamics NAV
, Microsoft Dynamics
, Microsoft Dynamics NAV 2016
, Microsoft Dynamics NAV 2017 | 0 Comments |
XML with SQL ServerXMLIt is all about describing data. Below is a XML which describes Patient data.11000001SionCat An XML tag is not something predefined but it is something we have to define according to our needs. The XML document is self-explanatory, anyone can easily understand looking at the XML data what exactly it means. “version” tag shows which version of XML is used. Root element is the top most element for a XML. Every tag in XML which is opened should have a closing ...
Service Broker SQL Server Service broker provides asynchronous queuing functionality to SQL Server. So now the end client will not have to wait. SQL Server Service broker uses both queues and asynchronous communication to fulfill its functionality. Queues are used because there may be instances that the other application with which we are interacting may not available. With the help of asynchronous communication, client sends message to the other end application and he can continue with som...
Introduction:Many new developer features were introduced in SQL Server 2008 database. This tutorial discusses the new top 10 developer features introduced in SQL server 2008.1. Change's in the DATE and TIME DataTypesIn SQL Server 2005, there were DATETIME or SMALLDATETIME data types to store datetime values but there was no specific datatype to store date or time value only. In addition, search functionality doesn't work on DATETIME or SMALLDATETIME fields if you only specify a data valu...
In this blog, I would like to explain about PIVOT and UNPIVOT operator in SQL Server. The PIVOT operator allows you to rotate data between columns and rows, performing aggregations along the way. UNPIVOT is the inverse of PIVOT, rotating data from columns to rows.Open Schema:I’ll use open schema as the scenario for pivoting attributes. Open schema is a design problem describing an environment that needs to deal with frequent schema changes. You can choose from several ways to model an open...