Author: Tamarian D2278
As we traverse through different versions of SQL Server, there are new enhancements that always make us learn for newer techniques. One such addition to SQL Server 2012 is called as Sequences. Sequences are just like a running number like Identity but are not attached to any table. In a nutshell, sequences generate a number which can be used anywhere agnostic of the…
Author: Embarcadero USA
Rapid SQL XE6 version 8.7.5 is now available.
EmbarcaderoRapid SQL is the integrated SQL development environment for IBM DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata database systems. Rapid SQL is your fast path to…
Author: Timur T7253
Introduction
Other than coding, the next biggest task for developers is to troubleshoot problems in their environments. Developers in the SQL world mostly face problems around error messages, getting required output via T-SQL query, and unpredictable…
Author: mahdy M7244
Introduction
When we are talking about relational database, we are usually talking about many different tables and the relationships between them. We define relationships with various keys like primary key, foreign key, etc. When we have to retrieve data from more than one table, we have to use Joins. In this article we will be discussing how we can code joins effectively and…
Author: jpro51
Working on universal applications has its own challenges. Often I have seen developers resort to unwanted conversions inside the database based on application needs. I am a firm supporter that databases are not the place to play with date and time conversions.
Author: Tim DelChiaro
Nobody would want to shy away from some help. This is second to human nature and we never try totalk it out explicitly. When at work, if we can surely get help from our colleagues when it comes to driving the deadlines and completing it ahead of…
Author: Wayne S8181
Monday, July 14, 2014: Lesson 3 – Accessing Local Storage and Data
In this lesson, we explore local storage covering a range of options including using INI files and local document storage. This lesson will also show how to use FireDAC database…
I have just returned from myRAD Studio XE3 World Tour stops in Europe. It was great to see so many young and old developers in London, Amsterdam, Warsaw and Heidelberg. In two cities I was asked whether there were any Object Relational Mapping solutions for…
Author: Michael K22532
JSON support has been introduced in Delphi 2010 as a part of DBExpress database driver architecture, but of course JSON support is not limited to just database applications. JSON is similar to XML as both are text-based data interchange formats.
Delphi 6 introduced “TXMLDocument” component and the “XML Data Binding Wizard” to make it easier to work with XML documents…
