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.
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 |