Stored procedures for adding or deleting a large number of cameras

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:

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.

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