Tag: database

SQL Server’s ISNULL() equivalent in PostgreSQL

SQL Server provides an function ISNULL if the value placed in the 2nd parameter if the first parameter passed to the function ISNULL is null. For example , SELECT ISNULL(Designation,’ ‘) from Employee This will …

WAITFOR TIME in SQL Server

If you want to pause the execution of the code block until a specific time is reached , you can try using the WAITFOR TIME statement in SQL Server. For example , you want the …

WAITFOR DELAY in SQL Server

If you want to pause the execution of the code block for a specific amount of time , you can try using the WAITFOR DELAY statement in SQL Server. For example , you want to …

Mission Critical Performance with SQL Server 2014

Microsoft Virtual Academy is hosting an Live Event on the topic Mission Critical Performance with SQL Server 2014 on December 3 , 2013 from 9:00am-5:00pm PST. The Mission Critical Performance with SQL Server 2014 course …

Degisy Data Suite for Delphi 7

Degisy Data Suite is a package of Visual Component Library ( VCL ) components for accessing the Paradox and DBASE Database . The components are inherited from the TDataSet class and thus guarantees a full compatibility …

ASP.NET MVC in Delphi Prism – Introduction

ASP.NET MVC is a web development framework from Microsoft that combines the effectiveness of the model-view-controller architecture . It is an alternative to the WebForms that was and is still mostly used one in ASP.NET . What …