Home >> Technologies >> T-SQL

Stored Procedures / T-SQL

Everything we build uses stored procedures for database integration to ensure a safe, fast database environment for your applications.

In order to utilize a secure environment for SQL database queries while maximizing performance and minimizing trips between the application and database, we put all our database logic in to stored procedures on Microsoft SQL Server databases.

Stored procedures are stand-alone objects that are built and reside on the database. They are outside of the Website coding environment.

Stored Procedures hold two distinct advantages over application based (inline) SQL database calls:
  1. They are safer. Inline SQL database queries are subject to script injection attacks. Stored procedures eliminate this security hazard.
  2. They are faster. Multiple SQL jobs related to one action can be put in to one stored procedure. This eliminates the need to go redundantly back and forth between the application and SQL database as each query executes in succession.
Stored procedures on Microsoft SQL Databases are written in their own programming language called T-SQL. T-SQL stands for Transact SQL. T-SQL is Microsoft's custom version of the SQL programming language built specifically to run on Microsoft's SQL Server Platform. T-SQL allows a database administrator to perform a variety of functions specific to managing and building robust SQL Server database solutions.

With our stored procedure techniques you can be sure that your SQL Database will be safe and your Website will run faster.

Home     About Us     Experience     Technologies     Sum of the Parts     Beyond the Code     Clients     Contact Us     Sitemap

© 1997 - 2020 TConsult Web Dev Inc.