Sql Server概念. [英] Sql Server Concepts.

问题描述

任何人都可以在Sql Server中的以下概念上为我提供帮助:-
1)交易.
2)光标.
3)复制.
4)查看.

在此先感谢.

Hi,

Any one can help me on the following concepts in Sql Server:-
1) Transaction.
2) Cursor.
3) Replication.
4) View.

Thanks in Advance.

推荐答案

1. 光标 [复制 [查看 [

1. Transaction[^]
2. Cursor[^]
3. Replication[^]
4. View[^]

交易记录:

Database transaction is a unit of work performed against a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. A database transaction, by definition, must be atomic, consistent, isolated and durable.

光标:

Cursor :

SQL Server cursors are database objects used to manipulate data in a set on a row-by-row basis. You can fetch cursor rows and perform operations on them in a loop just like using any looping mechanism found in any other programming language. Before you can use a cursor, you need to declare it.

复制:

Replication :

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.

查看:

View :

Views are a virtual table, Like a real table, a view consists of a set of named columns and rows of data. Unless indexed, a view does not exist as a stored set of data values in a database. The rows and columns of data come from tables referenced in the Sql statement defining the view and are produced dynamically when the view is referenced.

这篇关于Sql Server概念.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！