If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.
You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!
This is all inforamtion to get you started creating stored procedures inside of SQL server. This is not intended to cover advanced topics, but you should be abe to create basic stored procedures and execute them from the SQL server window.
About.com article - extremely simple article covering advantages of using stored procedures
Stored procedures in SQL Server are written (typically) in a language called Transact SQL or T-SQL for short. As you can see by the name that stored procedures are there for the control of transactions. The MSDN reference for T-SQL is at http://msdn2.microsoft.com/en-us/library/ms189826.aspx . For those using Oracle PL/SQL is the language of stored procedures. The reason they are called stored procedures is they are actually stored in the database. Every major database system supports stored procedures and most of them follow a language that is similar (PL/SQL and T-SQL look very much alike).
Comments (0)
You don't have permission to comment on this page.