SQL Server stored procedure one

What is a stored procedure

Stored procedures are functions similar to those in the C language that are used to perform administrative tasks or to apply complex business rules. Stored procedures can take parameters, or they can return results

(Contains data manipulation statements, variables, logical control statements, etc.)

Advantages and Disadvantages

Fast execution speed allows modular programming to improve system security and reduce network traffic

Disadvantage of poor database portability

Classification of stored procedures

System stored procedures are defined by the system and stored in the master database with names beginning with "sp_" or "xp_"

Sp_databases list all databases on the server

Sp_tables returns the list of objects that can be queried in the current environment

sp_helpdb report information about a specified database or all databases

Sp_renamedb modifying the name of the database

Sp_columns returns information for a table column

sp_help View all information for a table

Sp_helpconstraint viewing constraints on a table

Sp_helpindex to view the index of a table table

Sp_stored_procedures lists all stored procedures in the current environment

sp_password Add or modify password for login account

SP_HELPTEXT displays default values, unencrypted stored procedures, user-defined stored procedures, triggers, or actual versions of views

User-defined stored procedures that are created by the user in their own database

SQL Server stored procedure one