Versions Compared

Old Version 14

changes.mady.by.user Conor McCann

Saved on

compared with

New Version Current

changes.mady.by.user Conor McCann

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following stored procedure will add the DeviceID 3, 4, 5, 6, 7, 8, 20, 35, 23 to queue to delete the device. (Deletedby is to mimic what the UI would do)

Code Block
languagesql
Example:
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 3, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 4, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 5, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 6, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 7, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 8, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 20, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 35, @deletedBy = test
Exec [model].[sendDeviceToDeletionQueue] @deviceID = 23, @deletedBy = test

...