Stored procedures for adding or deleting a large number of objects

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

Run stored procedures in SQL Server Management Studio as follows:

1. Run SQL Server Management Studio (see Viewing INTELLECT™ software database).
   
2. Click the New Query button (1).
3. Specify the SQL query (2, see examples below).
4. Click the Execute button (3). If the query is executed successfully, then the corresponding message appears at the bottom of the window (4).

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.

   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.

   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