SQL Server system stored procedures Chinese description _mssql

/* Stored Procedures * *
Sp_databases--Lists all databases on the server
Sp_server_info-Lists server information, such as character set, version, and order
sp_stored_procedures--lists all stored procedures in the current environment
Sp_tables--Lists all the objects in the current environment that can be queried
Sp_start_job--Start automation task now
Sp_stop_job--Stop the automation task that is being performed
Sp_password--Add or modify the password for the login account
sp_configure--display (without options) or change (with options) global configuration settings for the current server
Sp_help--Returns the table's column name, data type, constraint type, etc.
Sp_helptext-Display rules, default values, unencrypted stored procedures, user-defined functions,
--Actual text of a trigger or view
Sp_helpfile--View Current database information
sp_dboption--Show or change database options
sp_detach_db--Detach the database
sp_attach_db--Additional database
Sp_addumpdevice--Adding devices
Sp_dropdevice--Removing devices
Sp_pkeys--View primary key
Sp_fkeys--View foreign keys
sp_helpdb--View the specified database related file information
Sp_addtype--Self-built data types
Sp_droptype--Deleting a self-built data type
sp_rename--Renaming a database
sp_executesql--Executing SQL statements
sp_addlogin--Add Login
Sp_droplogin--Delete Login
sp_grantdbaccess--mapping a user to a login, adding a database security account and granting tower access
sp_revokedbaccess--revoke a user's data access by deleting a security account from the database
Sp_addrole--Adding roles
sp_addrolemember--Adds a member to a role to make it a member of the database role
sp_addsrvrolemember--Modify the login to make it a member of the fixed server role
Sp_grantlogin-Allows you to use a group account or a system user to connect to SQL using Windows authentication
SP_DEFAULTDB--Modify the default database for a login
Sp_helpindex--for viewing the index of a table
Sp_cursoropen-Defines the SQL statement associated with the cursor and cursor options, and then generates a cursor
Sp_cursorfetch--fetching one or more rows from a cursor
Sp_cursorclose--Close and release cursors
Sp_cursoroption--Set various cursor options
Sp_cursor--For Request location update
Sp_cursorprepare-Compiles a T-SQL statement or batch related to a cursor into an execution plan, but does not create a cursor
Sp_cursorexecute-Create and populate cursors from the execution plan created by Sp_cursorprepare
Sp_cursorunprepare--Discard the execution plan generated by sp_cursorprepare
Sp_settriggerorder--Specifies the first or last after trigger that is associated with the table. In the first
-After triggers fired between the last trigger will be executed in undefined order