Shulou(Shulou.com)05/31 Report--

This article is to share with you about the common terms in SQL Server, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

The BEGIN TRANSACTION statement indicates that to start a user transaction, terminating a transaction when it encounters a COMMITTED command see COMMIT TRANSACTION or CANCLED see ROLLBACK TRANSACTION is a logical unit of work ion is a logical unit of work.

Database_name is the name of the database to be created. There are many different options, such as devices, that can be applied and the size of the database can be initialized when creating the database.

The CREATE PROCEDURE statement can create a new stored procedure in the database. The stored procedure can be composed of SQL statements and run by using the EXECUTE command to support input and output parameters and return an integer value for state detection.

CREATE TABLE can create a new table in the database. Each optional field provides the database with a definite field name and data type.

The CREATE TRIGGER statement can create a trigger mechanism that can be executed automatically when the database performs insert, update and delete operations, or it can call stored procedures to run complex tasks.

The DEALLOCATE CURSOR statement completely removes the cursor from memory and releases the name of the cursor so that it can be used by other cursors. You should use the CLOSE CURSOR command to close the cursor before releasing it.

The DECLARE CURSOR statement can create a new cursor from the SELECT statement FETCH statement can flip through the data in the cursor until the variable is loaded and then the cursor jumps to the next record

The DROP DATABASE statement can completely delete the database, including the data in the database and its physical structure on disk.

The DROP VIEW statement removes the view from the database

The EXECUTE command can run a stored procedure that contains SQL statements, and you can enter parameters during storage, and if the output keyword is used, the data can also be returned from the parameters.

The FETCH command loads the contents of the cursor into the supplied program variable. After the variable is loaded, the cursor jumps to the next record.

The ORDER BY statement can sort the content by specifying column sentences

The function of the ROLLBACK TRANSACTION statement is to cancel all work in a transaction from the time the BEGIN TRANSACTION statement runs

The REVOKE command removes all database permissions for a user, whether they are system permissions or rules

The SELECT statement is the beginning modifier of each statement that gets the data. DISTINCT can specify that it returns a duplicate number. ALL returns all data by default.

SET TRANSACTION allows the user to specify when the transaction should start. The READ ONLY option locks a set of recordsets until the transaction ends to ensure that the data has not been changed in the process.

The UNION statement returns all the elements in the two SELECT statements

The WHERE statement restricts that the returned rows must meet the specified conditions

These are the common terms in SQL Server, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.