.
insert intotKey ( InterfaceFieldID, ObjectID, Pkey, StrValue ) values( @InterfaceFieldID, @ObjectID, @Pkey, @StrValue ) | insert intotKey (InterfaceFieldID, ObjectID, Pkey, StrValue) values(@InterfaceFieldID, @ObjectID, @Pkey, @StrValue) |
4.3.3.3 insert values/select.
.
insert intotKey ( InterfaceFieldID, ObjectID, Pkey, StrValue ) values( @InterfaceFieldID, @ObjectID, @Pkey, @StrValue ) | insert intotKey (InterfaceFieldID, ObjectID, Pkey, StrValue) values(@InterfaceFieldID, @ObjectID, @Pkey, @StrValue) |
4.3.3.4 into".
.
insert intotKey ( InterfaceFieldID, ObjectID, Pkey, StrValue ) values( @InterfaceFieldID, @ObjectID, @Pkey, @StrValue ) | insert intotKey (InterfaceFieldID, ObjectID, Pkey, StrValue) values(@InterfaceFieldID, @ObjectID, @Pkey, @StrValue) |
4.3.3.5 into , insert values/select.
.
inserttKey ( InterfaceFieldID, ObjectID, Pkey, StrValue ) selectInterfaceFieldID, ObjectID, Pkey, StrValue from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID | inserttKey (InterfaceFieldID, ObjectID, Pkey, StrValue) selectInterfaceFieldID, ObjectID, Pkey, StrValue from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID |
80 , .
.
inserttKey (ObjectID,PKey) selectObjectID,PKey from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID |
UPDATE
: update {}
set { }
from { }
where { }
, .
.
updatetKey set Pkey = @Pkey, StrValue = @StrValue from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID | updatetKey set Pkey = @Pkey, StrValue = @StrValue from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID |
NULL, isnull.
|
|
.
updatetKey set Pkey = isnull(@Pkey, Pkey) from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID | updatetKey set Pkey = isnull(@Pkey, 0) from pKey M_NOLOCK_INDEX() where SPID = @@spid and InterfaceFieldID = @ID and ObjectID = @ObjectID |
DELETE
: delete {}
from { }
where { }
delete 80 , .
CURSOR
: __DECLARE_CURSOR__ MyCursor
{}
__DEALLOCATE_CURSOR__ MyCursor
.
.
__DECLARE_CURSOR__ MyCursor select ID from pTblCursor M_N where SPID = @@spid and Type = 1 open MyCursor fetch MyCursor into@ID while (__FETCH_STATUS__ = 0) begin {} fetch MyCursor into@ID end __DEALLOCATE_CURSOR__ MyCursor |