SQL Programming

Server side database programming using SQL allows us to write logic that can execute completely within the server database engine. This increases the application performance and reduces client/server network traffic specially when there are intensive calculations, many records to be processed and a lot of number-crunching. For slow performing applications, we move most of the application business logic to the stored procedures and triggers residing on the database server to reduce network traffic and processing time.

Persys, Inc. provides server side database for one of the four major databases:

Microsoft SQL Server

Sybase SQL Server

Oracle

IBM DB2

We use the following languages to write server side code:

Transact SQL

PL/SQL

Microsoft SQL Server XML features

Microsoft Data Transformation Services Packages

Other SQL Programming services include DTS packages which implement the server side coding using the Visual Basic Programming language. A DTS package is an organized collection of connections, DTS tasks, DTS transformations, and workflow constraints assembled either with a DTS tool or programmatically and saved to Microsoft® SQL Server™, SQL Server 2000 Meta Data Services, a structured storage file, or a Microsoft Visual Basic® file.