Page History

Intellect database has built'in pre-installed stored procedures for adding and deleting a large number of Camera, Tracker, VMDA Detection objects.

Running stored procedures

If lots of Camera objects are to be created or deleted, this can be done using dbo.spCopyCamera and dbo.spDeleteCameras stored procedures correspondingly. Run stored procedures in SQL Server Management Studio as follows:

...

You can find examples of using stored procedures below.

Examples of stored procedures use for adding or deleting Camera objects

If lots of Camera objects are to be created or deleted, this can be done using dbo.spCopyCamera and dbo.spDeleteCameras stored procedures correspondingly.

1. Take Camera 1 as an example and create 80 cameras with the same settings as Camera 1 has.

   Code Block
   USE [intellect] GO DECLARE @return_value int EXEC @return_value = [dbo].[spCopyCamera] @id = N'1', @count = 80 SELECT 'Return Value' = @return_value GO

   
   

2. Delete cameras from 3 to 33.

   Code Block
   USE [intellect] GO DECLARE @return_value int EXEC @return_value = [dbo].[spDeleteCameras] @fromId = 3, @toId = 33 SELECT 'Return Value' = @return_value GO

   
   

Example of stored procedure use for adding Tracker objects

Take Tracker 1 based on Camera 1 as an example and copy under all other cameras.

USE [intellect]
GO
DECLARE @return_value int
EXEC    @return_value = [dbo].[spCopyVmda]
        @id = N'1'
SELECT  'Return Value' = @return_value
GO

Example of stored procedure use for adding VMDA Detection objects

Take VMDA Detection 1 based on Tracker 1 as an example and copy under all other trackers.

USE [intellect]
GO
DECLARE @return_value int
EXEC    @return_value = [dbo].[spCopyVmdaDetector]
        @id = N'1'
SELECT  'Return Value' = @return_value
GO