Tags » SQL

Need to wrangle SQL, NoSQL data? Espresso Logic says it can help

Espresso Logic, which offers a backend service to help businesses connect applications with SQL data sources, is adding NoSQL to the mix with new support for MongoDB — as well as support for Salesforce.com and Microsoft Dynamics business applications coming soon. 364 more words

Count each number of table rows

Count each number of table rows

Oracle ACE Laurent Schneider has a more elegant solution for counting tables, using dbms_xmlgen to store the row counts for multiple tables in a single SQL query list: 44 more words


Are You Binding Your Oracle DATEs Correctly? I Bet You Aren't

Oracle database has its ways. In my SQL talks at conferences, I love to confuse people with the following Oracle facts:

… and the answer is, of course: 931 more words


[AX2012] Compare objects between models

SQL Makes everything better

When ever adding a new hot-fix or a new model from another source we need to compare the code touch points between that and existing code.

332 more words
Dynamics Ax

SQL SERVER - List the Name of the Months Between Date Ranges - Part 2

Last week I wrote a blog post about SQL SERVER – List the Name of the Months Between Date Ranges. It was written in the response to the question – How to list the name of the months between two date ranges? 190 more words

SQL Authority

DAX code connection to another SQL database

During data migration it is often necessary to pull data from another SQL server database. It can also be necessary for integration purposes. Below is some sample code that can be used to get data from another system. 128 more words


Sql Statements in C/AL – Part 2 : Create View

The following code can be used to create a sql view in a given, external database.

// local variables
ADOConnection	  Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection
ADOCommand	  Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Command
ADORecSet	  Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Recordset
connString	  Text 1024
activeConnection  Variant
viewName	  Text 100

// the code
// replace the server ip and the ext. 115 more words
Nav 2013