If I want to view the properties of a database, which system stored procedure can I use?

sp_helpdb [[dbname=] 'name'For example: exec sp helpdb mydb In SQL Server 2005, many administrative and information activities can be executed using the DU system storage process. System stored procedures can be grouped into the categories shown in the following table.

For the entire corresponding table, enter "System Stored Procedure" in MSDN to retrieve the table.

Active Directory stored procedures are used to register SQL Server instances and SQL Server databases in Microsoft Windows 2000 Active Directory.

sp_databases ？？All database size remarks.

A stored procedure is a block of programs with a name.

Storage means that after the program block is created, it is stored inside the database, and then we can call this program by some means in the program we wrote, and then this program will do one thing, what does it? How we write a stored procedure when we define it, and what it does when the time comes;

A process is a program block, and to put it bluntly, it is a program.

Stored procedures, after the creation is completed, are stored in the database, the database helps you remember, when the stored procedure is created, there is a name, in the future you are in your program, through a certain way (different programming languages have different ways), generally speaking, through this name, to call the stored procedure, just like using a method or function, it will do one thing!

The stored procedures of different databases are written in the programming language of the current database, such as Oracle's PL SQL programming, and so on.

I'll understand it by writing one myself, and I don't need to say more about the grammar, right?

Stored procedures are quite a method or function in SQL that works the same way in the program, and after you define it, you can call it directly, and pass it arguments if needed.

Write the name of the server, data source is your database name, and don't write database.

The stored procedure is to write the common or very complex work in advance with SQL statements and store them with a specified name, and such statements are placed in the database, and different SQL statements can also be executed according to the conditions, so when the database is called to provide the same service as the defined stored procedure, you only need to call execute, and the command can be automated. Advantages of Stored Procedures 1Stored procedures are only compiled at the time of creation, and they do not need to be recompiled every time they are executed in the future, while the SQL statements we usually use are compiled every time they are executed, so using stored procedures can improve the speed of database execution.

2.Complex business logic and database operations are often encountered, and SP is used to encapsulate database operations. When performing complex operations on a database, such as update, insert, query, and delete multiple tables, this complex operation can be encapsulated with stored procedures in conjunction with the transaction processing provided by the database.

It can greatly improve the efficiency of database use and reduce the execution time of programs, which is very important in the operation of databases with large data volumes. On the other hand, the separation of SQL statements and program statements can improve the readability of programs. 3.

Stored procedures can be set with parameters, and the same stored procedure can be reused according to the different parameters incoming, so as to effectively improve the optimization rate and readability. 4.High security, you can set the type of stored procedure that only a certain user has the right to use the specified stored procedure:

1) System storage procedure: It starts with sp and is used to set various settings of the system. Get information.

Related management work, such as sp help, is to get information about the specified object. (2) Extended stored procedures start with xp and are used to call the function provided by the operating system, exec masterxp_cmdshell 'ping '(3) User-defined stored procedures, which are the common formats of stored procedures that we refer to Template:

create procedure procedue name [@parameter data type][output][with] as sql statement Explanation: output: indicates that this parameter is passable back with recompile:

Indicates that this stored procedure is recompiled each time it is executed; encryption: The contents of the stored procedure created are encrypted.

sp_helpdb [[dbname=] name'For example: exec sp helpdb mydb In SQL Server 2005, many administrative and information activities can be executed using the DU system storage process. System stored procedures can be grouped into the categories shown in the following table.

For the entire corresponding table, enter "System Stored Procedure" in MSDN to retrieve the table.

Active Directory stored procedures are used to register SQL Server instances and SQL Server databases in Microsoft Windows 2000 Active Directory.

() is stored in the database.

a.Data. b.Data model.

c.Data and the relationships between data.

d.Information. Correct answer: c

A stored procedure.

It is not only a standard component of a system, but also a programmable function, which is created and stored in the database, and in general, there are several types of stored procedures in a relational database system.

1.System storage processThe system storage process starts with sp, which is used to set up the system quietly, obtain the information of the system, and manage the related work of the system.

2.Local Stored ProceduresLocal stored procedures are a set of SQL statements created by a user to accomplish a specific function. In fact, what we call a stored procedure in general is a local stored procedure.

3.Temporary Stored ProceduresTemporary stored procedures are divided into two types: local temporary stored procedures and global temporary stored procedures.

1) Local temporary stored procedures. With the hash sign ( ) as the first character of its name, the stored procedure becomes a local temporary stored procedure stored in the tempdb database, and only the user who created it can execute it.

2) Global temporary stored procedures. Starting with two hash marks ( ), the stored procedure becomes a global temporary stored procedure stored in the tempdb database. Once a global temporary stored procedure is created, it can be executed by any user connected to the server in the future, and the slippage does not require specific permissions.

4.Remote Stored ProceduresIn a particular database, a remote stored procedure is a stored procedure that resides on a remote server, and can usually be executed using distributed queries and execute commands.

5.Extended stored proceduresExtended stored procedures are stored procedures written by users in an external programming language, and the name of the extended stored procedure usually starts with xp.

3).Stored procedure classification<1>System Stored ProceduresSystem Stored Procedures (system

stored

procedures) are mainly stored in the master database and prefixed with sp, and the system stored procedures are mainly used to obtain information from system tables to manage SQL for system administrators

server. <2>.Local Stored ProceduresLocal Stored Procedures (local

stored

procedures) are stored procedures that are created by the user in the user database. In fact, the most commonly referred to stored procedure value is the local stored procedure. A user-created stored procedure is a stored procedure created by a user that can perform a specific function, such as querying the data information required by the user.

3>.Temporary Stored ProceduresTemporary Stored Procedures (temporary

stored

procedures) can be divided into the following two types: aIf a local temporary stored procedure uses a pound sign ( ) as the first character of its name during the creation of a stored procedure, the stored procedure shortener becomes a local temporary stored procedure stored in the tempdb database (for example, create

procedure

#book_proc...A local temporary stored procedure can only be executed by the user who created the connection to it, and once that user is disconnected from the SQL

server, the local temporary stored procedure will be automatically deleted, of course, this user can also use drop during the connection

procedure command to delete multiple created local temporary stored procedures. b.If the global temporary stored procedure is created in the storage split, the early procedure name is based on two pounds (

), the stored procedure becomes a global temporary stored procedure stored in the tempdb database, and if not, the global temporary stored procedure is deleted immediately; If there is, sql

The server will continue these ongoing operations, but will not allow any users to execute the global temporary stored procedure, and will automatically delete it when all outstanding operations have been executed. Since the global ephemeral stored procedure can be used by all connected users, it is important to note that its name cannot be the same as that of other connections. <4>.

Remote Stored ProcedureRemote Stored Procedure (remote

stored

procedures) are stored procedures that reside on a remote server, and can typically be executed using distributed queries and execute commands.

A stored procedure is a block of programs with a name.

A process is a program block, and to put it bluntly, it is a program.

Stored procedures, after the creation of the town, it is stored in the database, the database helps you remember, the stored procedure has a name when it is created, and in the future, you will be in your program, through a certain way (different programming languages have different ways), generally speaking, through this name, to call the stored procedure, just like using a method or function to answer the defeat, it will do one thing!

The stored procedures of different databases are written in the programming language of the current database, such as oracle's fluttering PL SQL programming, and so on.