Go to documentation repository
Documentation for Intellect 4.10.4. Documentation for other versions of Intellect is available too.
Previous page Next page
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:
- Run SQL Server Management Studio (see Viewing INTELLECT™ software database).
- Click the New Query button (1).
- Specify the SQL query (2, see examples below).
- 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.
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
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
Overview
Content Tools