4.1.17 goto ( ).
. . .
.
declare @RetVal int, @ObjectID DSIDENTIFIER | declare @RetVal int, @ObjectID DSIDENTIFIER declare @RetVal int, @i int |
, .
.
fetch MyCursor into @ID, @Value | fetch MyCursor into @ID, @Value |
fetch 80 , .
4.1.21 ID , , , . :
a. Property.sql tProperty
b. IntObj.sql tInterfaceObject ..
. , Dispatch- .
4.1.23 , .. .
@Param type = null. .
( ).
4.1.25 PROFILE_BEGIN_EX(' - start [. ]'), return PROFILE_END_EX(' - finish [end] [. ]'). , , PROFILE_TIME_VAR... PROFILE_TIME... , , . ( , ).
BEGIN_PROC, _ - END_PROC, .
run-time : M_LOG_INFO ( . ), M_LOG_ERROR ( ) M_LOG_DEBUG ( , )
M_FORCEPLAN . from , set forceplan on. M_FORCEPLAN_OFF set forceplan off. ( , , - )
|
|
4.1.27 UPDATE DELETE, FROM M_FORCEORDER, ANSI- (inner join). M_FORCEORDER UPDATE DELETE, , / , FROM -ANSI . ( MS SQL ( FORCE ORDER!) , UPDATE/DELETE, FROM).
, 2 M_FORCEORDER , ( , ).
4.1.29 set forceplan on/off ( MS SQL).
4.1.30 ( ) ( , , , ).
4.1.31 , ( WHERE) DECLARE CURSOR OPEN <> ( Sybase MS SQL, , ).