签署预存程序需要实作许多步骤。
Signing stored procedures requires several steps to implement.
否则,预存程序会传回错误。
预存程序、函式或检视的巢状层超过32。
The nesting level of a stored procedure, function, or view exceeds 32.
若要解决这个错误,您可以移除该预存程序。
To resolve the error, you could remove that stored procedure.
使用者只能透过提供的预存程序来存取资料。
Users can only access data through the stored procedures provided.
说明如何使用预存程序撷取实体类型的集合。
Shows how to use a stored procedure to retrieve a collection of entity types.
建立新的预存程序。
描述如何为在相同预存程序中传回多个图案做准备。
Describes how to provide for returns of multiple shapes in the same stored procedure.
单靠撰写预存程序并不能够确保应用程序的安全性。
Simply writing stored procedures isn't enough to adequately secure your application.
然后,您可以建立参数化预存程序,并传入适当的值。
You then create parameterized stored procedures, passing in the appropriate value.
往后每当要指定不同聘雇日期时,即可执行预存程序。
You can then run the stored procedure each time you want to specify a different hire date.
取得或设定方法是对应至函式,还是对应至预存程序。
Gets or sets whether a method is mapped to a function or to a stored procedure.
预存程序和函式也会呈现,而且会自动将资料表名称复数化。
Stored procedures and functions are also rendered, and table names are automatically pluralized.
您可以在预存程序及使用者定义函式中,执行已选取的文字。
You can run selected text in stored procedures and user-defined functions.
与一般的RDBMS完全不同,它缺乏数据库触发和预存程序。
RDBMS in general is completely different from its lack of database triggers and stored procedures.
请注意,这个预存程序并不会变更已关联于指定设定档的帐户序号。
Notice that this stored procedure does not change the sequence number of an account already associated with the specified profile.
说明如何将查询所定义的概念模型使用LINQ和预存程序的资料。
Describes how to query data that is defined by a conceptual model by using LINQ and stored procedures.
由于预存程序比SQL陈述式快许多,因此可选择本选项以改善效能。
Because stored procedures can be faster than SQL statements, you might choose this option for performance.
例如,您可能汇入了预存程序,但是该程序参考一个已不存在的表格。
For example, you might import a stored procedure that references a table that no longer exists.
您可开启预存程序和使用者定义函式,以检视或编辑SQL文字。
You can open stored procedures and user-defined functions to view or edit the SQL text.
会出现 [查询产生器],您可以在这里使用预存程序或使用者定义函式。
The Query Builder comes up where you can work with your stored procedure or user-defined function.
描述如何将资料载入资料集,以及如何执行预存程序并对资料库执行查询。
Describes how to load data into datasets, and how to execute stored procedures, and execute queries against a database.
每一项物件都包含了SQL陈述式,或者用来读取和写入资料的预存程序名称。
Each of these objects contains either a SQL statement or the name of a stored procedure used to read and write data.
为SQL陈述式或预存程序建立和组态参数,以便命令可读取和写入正确的资料。
Creates and configures parameters for the SQL statements or stored procedures so that the commands read and write the correct data.
例如,预存程序可以呼叫其他的预存程序,或者预存程序也可以存取多个资料表。
For example, a stored procedure can call other stored procedures, or a stored procedure can access multiple tables.
最后,在资料库需要透过预存程序进行资料表存取时,也可以覆写预设更新行为。
Finally, you can override the default update behavior when the database requires table access through stored procedures.
如果您尝试撷取多版本预存程序的结构描述资讯,只会传回最新版本的结构描述。
If you attempt to retrieve schema information for more than one versioned stored procedure, the schema for the latest one only is returned.
本选项于使用陈述式十分相似,唯一的不同点是,精灵可产生预存程序而非陈述式。
This option is similar to using a statement, except that the wizard generates stored procedures instead of statements.
如需详细资讯,以及预存程序和使用者定义函式的范例,请参阅您的资料库伺服器文件。
For more information and examples of stored procedures and user-defined functions, see the documentation for your database server.
如需详细资讯,以及预存程序和使用者定义函式的范例,请参阅您的资料库伺服器文件。
For more information and examples of stored procedures and user-defined functions, see the documentation for your database server.
应用推荐