What is a Stored Procedure in MS SQL Server?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a Stored Procedure in MS SQL Server?

A Stored Procedure in MS SQL Server is a unit of precompiled T-SQL statements stored in the server and is ready to be executed.

(Continued on next question...)

Other Job Interview Questions

• What is a Page in MS SQL Server?
• What is a Page in MS SQL Server?
• What is a Rule is MS SQL Server?
• What is the meaning of an Outer Join operatin of two tables?
• What does RDBMS stand for?
• What can you do with the "ALTER DATABASE ..." T-SQL command?
• In what situation you should the "sp_showfilegroup" stored procedure?
• Does MS SQL Server support IPX/SPX?
• What is the meaning of an Outer Join operatin of two tables?
• What is a Page in MS SQL Server?
• More...