Archive by tag: SQL ServerReturn

NAV – Connecting External SQL

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).
Read More

XML with SQL Server

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 ...
Read More

New Features in Sql Server 2008

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...
Read More

Pivoting and Unpivoting Data In SQL Server 2008

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...
Read More

  • Recent
  • Popular
  • Tag
Monthly Archive
Subscribe
Name

Contact Us
  • *
  • *