Abstract
Stored procedures (SPs) have been a part of T-SQL from the beginning. SPs provide a means for creating server-side subroutines written in T-SQL. SQL Server 2014 introduces the ability to natively compile an SP that accesses memory-optimized tables. The efficiencies gained with natively compiled SPs are an absolute game-changer in how you consider architecting an OLTP database solution.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Miguel Cebollero
About this chapter
Cite this chapter
Cebollero, M., Natarajan, J., Coles, M. (2015). Stored Procedures. In: Pro T-SQL Programmer's Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0145-9_5
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0145-9_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0146-6
Online ISBN: 978-1-4842-0145-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books