避免给资料库物件过长的名称。
您可以定义单元测试,以验证资料库物件的行为。
You can define unit tests to verify the behavior of your database objects.
建立或开启一个尚未包含资料库物件的资料库专案。
Either create or open a database project that does not already contain database objects.
系统管理员和资料库拥有者可以存取所有的资料库物件。
System administrators and database owners can access all database objects.
如此即可有效地在资料和资料库物件周围建立安全性防线。
This effectively creates a security perimeter around your data and database objects.
下列程序将说明如何为任何资料库物件建立资料库单元测试。
The following procedures explain how to create database unit tests for any database object.
在详细资料窗格中,按一下您要建立之资料库物件类型的范本。
In the details pane, click the template for the type of database object that you want to create.
因为资料库物件只有为了回应资料库中的动作或呼叫时才会执行。
This is because database objects run only in response to actions or calls in the database.
此资料库物件会加入到资料库专案属性所指定的预设结构描述中。
The database object is added in the Default Schema specified in the database project properties.
当您重新命名资料库物件时,资料库专案的重构记录中会加入一个项目。
When you rename a database object, an entry is added to the refactoring log for your database project.
使用方案总管为每一个资料库物件维护一组资料库参考非常实用,其原因如下。
Using Solution Explorer to maintain a set of database references for each database project is useful for several reasons.
DAC包括资料库物件(例如资料表与检视表)以及执行个体实体(例如登入)。
A DAC includes database objects, such as tables and views, together with instance entities such as logins.
您可以建立资料库物件和设定的离线表示并进行版本控制,来管理资料库的变更。
You can manage changes to a database by creating an offline representation of its objects and Settings, and putting that representation under version control.
本主题说明将资料库重构作业套用至一个或多个资料库物件之后,如何恢复变更。
This topic explains how to undo the changes after you apply database refactoring operations to one or more database objects.
测试资料库之前,您必须先建立包含资料库物件和设定之离线表示的资料库专案。
Before you can test a database, you must first create a database project that contains the offline representation of the objects and Settings for the database.
建立资料库的基准状态之后,您就可以执行反复开发工作,例如定义和更新资料库物件。
After you establish a baseline state for your database, you perform iterative development tasks such as defining and updating database objects.
这个对话方块将同时显示资料库物件清单,其中包含储存资料表时将会受到影响的所有物件。
This dialog box also displays a list of database objects that will be affected as a result of saving your table.
将单元测试包含在资料库专案中来验证您对资料库物件所做的变更时,并不会中断现有的功能。
Include unit tests in your database project to verify changes you make to database objects do not break existing functionality.
当您执行此功能时,就会建立全新的DDL指令码,将会移除,然后重新建立所有资料库物件。
When you run the feature, it will create a completely new DDL script that will remove and then recreate all of the database objects.
预存程序可以利用拥有权链结提供对资料的存取,如此使用者即使没有明确的权限,也可以存取资料库物件。
Stored procedures take advantage of ownership chaining to provide access to data so that users do not need to have explicit permission to access database objects.
如果您想要将资料库物件加入至不是空的专案中,您必须使用不同的程序来汇入其他物件或是变更现有的物件。
If you want to add database objects to a project that is not empty, you must use a different procedure to import additional objects or to change existing objects.
系统会剖析您所指定的指令码,而且会识别建立资料库物件的任何陈述式,并将这些陈述式汇入到资料库专案。
The script that you specified is parsed, and any statements that create database objects are identified and imported into the database project.
您可以定义单元测试来验证资料库物件的行为,以及将每一个测试专案与不同的资料产生计划、部署组态和连接字串产生关联。
You can define unit tests to verify the behavior of your database objects and associate each test project with a different data generation plan, deployment configuration, and connection string.
将资料库物件移至不同的结构描述:您可以使用重构将资料库物件移至另一个结构描述,并自动更新资料库专案中该物件的所有参考。
Move a database object to a different schema: you can use refactoring to move a database object to another schema and automatically update all references to that object in your database project.
如果你是后端开发者,专注在学习如何塑模你的应用领域成为一组资源,建立你的资料库表格,然后使用物件。
If you're a back-end developer, concentrate on learning how to model your application domain as a set of resources, create your database tables, and use the resulting objects.
窗口修饰中的相同文本输入字段允许搜索存储库中包含某些单词的工作物件。
The same text entry field in the window trim allows to search the repository for work items that contain certain words.
于是你得到物件被称作“ angle _ of _repose ”,它有著所有从资料库捞出来的资料。
And you have an object, which you've named "angle_of_repose," that has all the information from the appropriate database record.
有了ORM,你可以操作代表资料的软体物件,然后Activerecord函式库将会处理与资料库的操作。
With ORM, you can work with software objects that represent your data and let the Active Record library take care of communicating with the database.
你的程序码与model物件互动,然后ActiveRecord产生SQL让资料库如你所写。
Your code interacts with the model objects, and Active Record creates the SQL to make the database do what you want.
您期望物件模型能维持某种假象,那就是资料库的记忆体中扩充具有立即可用的相关物件。
You expect your object model to maintain an illusion that it is an in-memory extension of the database with related objects immediately available.
应用推荐