E-mail
The Virtual Ticket, Job Manager, Digital Storage Manager, and Approval Manager products utilize Microsoft SQL Server as back-end database servers. The following is an overview of Microsoft SQL Server’s advanced features, an understanding of which is necessary to work with SQL SDK.
Stored Procedures - A stored procedure is a collection of parameterized T-SQL statements that is permanently saved on Microsoft SQL Server. Once saved, it can be later activated from other T-SQL scripts. Stored procedures are saved in each MS SQL database independently.
Triggers - A trigger is a special kind of stored procedure that executes automatically when a user attempts the specified data-modification statement on the specified table. Triggers can call other stored procedures. Certain T-SQL statements are prohibited in code executed as a result of firing a trigger.
Jobs - A job is a collection of T-SQL statements that is executed by the SQL Server Agent according to an assigned schedule.