Increased security for value-generating processes(e.g. storage processes).
When would you use the stored procedures or functions?Cloudera为客户提供了存储过程和分析大数据的场所。
Cloudera gives clients a place to store process and analyze Big Data.Combinations with other parts of speech
CommandType为StoredProcedure的时候,存储过程是通过RPC来执行的。
CommandType of StoredProcedure, the stored procedure is executed via RPC.
Every Database has its own language to create the Stored Procedure.
Create& maintain other database objects such as stored procedures, views, etc.虽然这些存储过程和函数为SQLServer所特有,但它们使用户与基础系统目录表的结构隔离开了。
Although these stored procedures and functions are specific to SQL Server, they insulate users from the structure of the underlying system catalog tables.当编写存储过程、触发器、用户自定义函数时,你现在要决定是使用传统的Transact-SQL还是.
When writing stored procedures, triggers, and user-defined functions, programmers now will have to decide whether to use traditional T-SQL or a.除了它们昂贵的事实之外,这种电子设备由于制造,运输和存储过程而也是能量足迹。
Such electronic devices apart from the fact that they are expensive are also an energy footprint because of manufacturing,transportation and storage processes.(4)存储过程在创建时即在上进行编译,所以执行起来比单个SQL语句快。
(4)A stored procedure is created that is compiled in, so to implement than a single SQL statement soon.购买额外的土地对于简化我们的运营以及巩固我们的生产,制造,包装和存储过程将至关重要,”Andrea补充说。
Purchasing additional land will prove vital to streamlining our operations and consolidating our production, fabrication,packaging and storage processes,” added Andrea.可维护性高更新存储过程通常比更改、测试以及重新部署程序集需要较少的时间和精力。
Updating the stored procedure will usually take less time and effort than changing, testing, and re-deploying your assembly.存储过程可以访问或修改数据库中的数据,但它不依赖于特定的数据库或对象。
Stored procedures can access or modify data in a database, but it is not tied to a specific database or object.存储过程期间,交换机分析帧以获得有关其目的地的信息。
During the storage process, the switch analyzes the frame for information about its destination.类似的情况也适用于生产物流,它涉及规划、控制和监测内部运输、处理和存储过程。
A similar situation applies to production logistics, which deals with planning, controlling, and monitoring internal transportation,handling, and storage processes.
The six steps described hereare meant as a way to conceptualize the blockchain storage process.这时,存储过程将被启动,另外过两小时后,被清理的数据将驻留在数据仓库中。
At which time, a stored procedure would be kicked off and(after another two hours) the cleansed data would reside in the data warehouse.Hibernate3.x允许使用手写SQL语句,包括存储过程,所有的创建,更新,删除和load操作。
Hibernate3 allows you to specify handwritten SQL, including stored procedures, for all create, update, delete, and load operations.
Allows users to create a view, stored procedure, functions in a database.最后,存储过程可以运行多个SQL语句、调用函数,甚至迭代结果集、执行类似于编程代码的复杂操作。
Finally, stored procedures can execute multiple SQL statements, call functions, and even iterate over results sets, performing complex operations akin to programming code.要通过T-SQL删除某个特定的用户,仅仅需要调用存储过程aspnet_Users_DeleteUser,并传入相应的参数即可:.
To delete a particular user through T-SQL,simply call the aspnet_Users_DeleteUser stored procedure passing in the appropriate parameters.存储过程中接受输入参数,以便多个客户端可以使用单个输入数据通过网络使用单个过程。
Stored procedures accept input parameters so that a single procedure can be used over the network by several clients using different input data.以这种方式定义存储过程或函数时,将创建一个连接到外部DLL中函数的桥。
When you define a stored procedure or function in this way, you are creating a bridge to the function in the external DLL.有些MySQL版本还缺乏完整的存储过程支持-意味着不支持事务,这是MyISAM系统的最大缺点。
Several version of MySQL also lack full support for several stored procedures which is the biggest disadvantage for the MyISAM system which doesn't support transactions.例如,在存储过程中,使用明确的日期格式可以防止按照用户的date_order设置错误地解释日期。
For example, in stored procedures, use of the unambiguous date format prevents misinterpretation of dates according to the user's date_order setting.当存储过程和函数被执行的时候,SQLManager会到procedurecache中去取相应的查询语句,如果在.
When the stored procedure and function is executed, SQL will Manager to query for the corresponding procedure cache, if the.在存储过程方面,我们正在计划支持Perl、pgSQL、Tcl和JavaScript(通过V8JavaScript引擎)。
On the stored procedure side, we are planning to support Perl, pgSQL, Tcl, and JavaScript(via the V8 JavaScript engine).