labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_GetCommands
Parameters
Name
Type
Mode
CID
int
IN
Definition
BEGIN START TRANSACTION; UPDATE commands SET STATUS=1 WHERE STATUS=0 AND ComputerID=CID; SELECT CmdID,Command,Parameters FROM commands WHERE STATUS=1 AND ComputerID=CID; UPDATE commands SET STATUS=2 WHERE STATUS=1 AND ComputerID=CID; COMMIT; END