API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 23rd, 2018
108
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 15.00 KB | None | 0 0
raw download clone embed print report
  1. CREATE FUNCTION [dbo].[SplitArrayIDs]  (   @ArrayList varchar(max)  )  RETURNS   @ParsedList table  (   ArrayID int  )  AS  BEGIN   DECLARE @ArrayID varchar(10), @Pos int     SET @ArrayList = LTRIM(RTRIM(@ArrayList))+ ','   SET @Pos = CHARINDEX(',', @ArrayList, 1)     IF REPLACE(@ArrayList, ',', '') <> ''   BEGIN    WHILE @Pos > 0    BEGIN     SET @ArrayID = LTRIM(RTRIM(LEFT(@ArrayList, @Pos - 1)))     IF @ArrayID <> ''     BEGIN      INSERT INTO @ParsedList (ArrayID)       VALUES (CAST(@ArrayID AS int))     END     SET @ArrayList = RIGHT(@ArrayList, LEN(@ArrayList) - @Pos)     SET @Pos = CHARINDEX(',', @ArrayList, 1)      END   END    RETURN  END  
  2. -- =============================================  -- Author:  Name  -- Create date:   -- Description:   -- =============================================  CREATE PROCEDURE [dbo].[spUpdateNetworkStatus]    -- Add the parameters for the stored procedure here   @IdNetwork int ,    @wStatus int   AS  BEGIN   -- SET NOCOUNT ON added to prevent extra result sets from   -- interfering with SELECT statements.   SET NOCOUNT ON;        -- Insert statements for procedure here   Update tblNetworks   Set wStatus = @wStatus   Where IdNetwork = @IdNetwork    END      
  3. CREATE PROCEDURE [dbo].[spUpdatePanelStatus]    @IdPanel int ,    @wStatus int ,   @wSounder int ,   @wSounderManual int,      @bEnabled bit,        @bAuxStatus bit ,    @bBatteryStatus bit ,   @bCaseTamper bit,   @bVInStatus bit,      @bVOutStatus bit,        @bReadersVoltage bit     AS  BEGIN   -- SET NOCOUNT ON added to prevent extra result sets from   -- interfering with SELECT statements.   SET NOCOUNT ON;        -- Insert statements for procedure here   Update tblPanel   Set wStatus = @wStatus,   wSounder = @wSounder,   wSounderManual = @wSounderManual,      bEnabled = @bEnabled,      bAuxStatus = @bAuxStatus,   bBatteryStatus = @bBatteryStatus,      bCaseTamper = @bCaseTamper,      bVInStatus = @bVInStatus,   bVOutStatus = @bVOutStatus,      bReadersVoltage = @bReadersVoltage   Where IdPanel = @IdPanel    END        
  4. (@1 nvarchar(4000),@2 varchar(8000),@3 int,@4 nvarchar(4000),@5 nvarchar(4000),@6 int,@7 nvarchar(4000),@8 int)INSERT INTO [tblMessages]([tEvent],[dtDate],[IdPanel],[tLocation],[tEventEng],[bIndex],[tOperator],[bSucceed]) values(@1,CONVERT([datetime],@2,(120)),@3,@4,@5,@6,@7,@8)
  5. DELETE FROM tblMassDownload WHERE IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloads);DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM  ViewDownloadsUnattached);
  6. DELETE FROM tblMassDownload WHERE IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloads);DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM  ViewDownloadsUnattached);
  7. (@1 int,@2 int,@3 nvarchar(4000),@4 int,@5 int,@6 int,@7 varchar(8000),@8 int,@9 varchar(8000),@10 int,@11 int,@12 tinyint)UPDATE [tblCard] set [iFacilityCodeSecond] = @1,[eCardType] = @2,[tDescCard] = @3,[eCardStatus] = @4,[IdEmpNum] = @5,[IdCardNum] = @6,[dtSaved] = CONVERT([datetime],@7,(120)),[iCardCode] = @8,[dtLastUsed] = CONVERT([datetime],@9,(120)),[iSiteCode] = @10,[iIssueNumber] = @11  WHERE [IdCardNum]=@12
  8. SELECT DISTINCT IdCardNum FROM tblCard ORDER BY IdCardNum
  9. SELECT TOP 1 iEmployeeNum, tPhotoFile, imgPicture FROM tblEmployees WHERE iEmployeeNum=2
  10. SELECT * FROM ViewFreePanel WHERE IdAccessGroup=1
  11. SELECT * FROM tblDepartment ORDER BY IdDepartment
  12. SELECT COUNT(*) FROM tblCardDesign
  13. (@1 tinyint)SELECT * FROM [tblNetworks] WHERE [IdNetwork]=@1
  14. SELECT *  FROM tblUserField ORDER BY IdField
  15. (@iEmployeeNum int)DELETE FROM tblEvents WHERE IdEmpNum=@iEmployeeNum;
  16. (@Ids nvarchar(1))SELECT iEmployeeNum, tLastName, tFirstName FROM viewUserDetails v INNER JOIN SplitArrayIDs(@Ids) arr ON v.iEmployeeNum = arr.ArrayID
  17. (@1 tinyint)SELECT [IdEmpNum] FROM [tblCard] WHERE [IdCardNum]=@1
  18. (@1 int,@2 int,@3 int)INSERT INTO [tblSlotCard]([IdPanel],[IdCardNum],[IdCardSlot]) values(@1,@2,@3)
  19. SELECT * FROM ViewPanelByUserOnly WHERE IdUserNum=2
  20. SELECT COUNT(*) FROM tblDownloadFailed
  21. (@1 tinyint)SELECT * FROM [tblNetworksDaylight] WHERE [IdNetwork]=@1
  22. SELECT IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1, STUFF((SELECT ',' + CONVERT(VARCHAR(50), IdInfo) FROM tblMassDownload WHERE tblMassDownload.IdDownload = tblDownloadFailed.IdDownload AND bFailed=1 FOR XML PATH('')), 1, 1, '') [IdInfos] FROM tblDownloadFailed WHERE IdPanel=1 GROUP BY IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1 ORDER BY IdDownload
  23. SELECT * FROM ViewPanelCardSlot WHERE (IdPanel=1) AND (IdCardNum=3)
  24. SELECT * FROM ViewPanelCardSlot WHERE (IdPanel=1) AND (IdCardNum=2)
  25. SELECT * FROM ViewPanelByCardOnly WHERE IdCardNum=2
  26. SELECT  TOP 1 * FROM ViewPanelUserSlot WHERE (IdPanel=1) AND (iEmployeeNum=2)
  27. SELECT *  FROM ViewViTraxServerCameraPanelNetwork ORDER BY IdCamera
  28. (@1 int,@2 int,@3 nvarchar(4000),@4 int,@5 int,@6 int,@7 varchar(8000),@8 int,@9 varchar(8000),@10 int,@11 int)INSERT INTO [tblCard]([iFacilityCodeSecond],[eCardType],[tDescCard],[eCardStatus],[IdEmpNum],[IdCardNum],[dtSaved],[iCardCode],[dtLastUsed],[iSiteCode],[iIssueNumber]) values(@1,@2,@3,@4,@5,@6,CONVERT([datetime],@7,(120)),@8,CONVERT([datetime],@9,(120)),@10,@11)
  29. DELETE FROM tblMassDownload WHERE IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloadFaileds);DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM  ViewDownloadsUnattachedFailed);
  30. DELETE FROM tblMassDownload WHERE IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloadFaileds);DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM  ViewDownloadsUnattachedFailed);
  31. (@1 tinyint)DELETE [tblSlotUser]  WHERE [IdUserNum]=@1
  32. (@1 tinyint)DELETE [tblUserStatus]  WHERE [IdEmp]=@1
  33. SELECT EmployeeID, OutputGroupID, TimezoneID, dtTimer,  STUFF((SELECT ',' + CONVERT(VARCHAR(50), ReaderID) FROM tblAutoOpenReaders WHERE tblAutoOpenReaders.EmployeeID = tblAutoOpen.EmployeeID FOR XML PATH('')), 1, 1, '') [IdReaders] FROM tblAutoOpen WHERE EmployeeID=2 GROUP BY EmployeeID, OutputGroupID, TimezoneID, dtTimer ORDER BY EmployeeID
  34. (@1 int,@2 tinyint,@3 tinyint)SELECT * FROM [tblCard] WHERE CONVERT([numeric](20,0),[iCardCode],0)=@1 AND [iSiteCode]=@2 AND [eCardType]=@3
  35. SELECT r.ReportId, r.ReportType, r.Name, r.Description, r.UpdatedAt                    ,s.ReportId AS ScheduleId, s.IntervalType, s.IntervalValue, s.TimeAt, s.StartingAt, s.EndingAt, s.NextAt, s.FileName, s.FileType                       ,a.Arguments, a.Layout                FROM tblReportDetails r                INNER JOIN tblReportArguments a ON r.ReportId = a.ReportId                LEFT JOIN tblReportSchedule s ON r.ReportId = s.ReportId WHERE s.NextAt < GETDATE() AND (s.EndingAt IS NULL OR s.NextAt < s.EndingAt)
  36. SELECT DISTINCT IdCardSlot FROM tblSlotCard WHERE IdPanel = 1 ORDER BY IdCardSlot
  37. (@1 nvarchar(4000),@2 nvarchar(4000),@3 varchar(8000),@4 int,@5 nvarchar(4000),@6 nvarchar(4000),@7 int,@8 nvarchar(4000),@9 int,@10 nvarchar(4000))INSERT INTO [tblMessages]([tDetailsEng],[tEvent],[dtDate],[IdPanel],[tLocation],[tEventEng],[bIndex],[tOperator],[bSucceed],[tDetails]) values(@1,@2,CONVERT([datetime],@3,(120)),@4,@5,@6,@7,@8,@9,@10)
  38. (@iEmployeeNum int)DELETE FROM tblEmployees WHERE iEmployeeNum=@iEmployeeNum;                                          DELETE FROM tblEmployeeUserField WHERE iUserId=@iEmployeeNum;
  39. (@iEmployeeNum int)DELETE FROM tblEmployees WHERE iEmployeeNum=@iEmployeeNum;                                          DELETE FROM tblEmployeeUserField WHERE iUserId=@iEmployeeNum;
  40. SELECT * FROM tblCard WHERE IdEmpNum=2
  41. SELECT TOP 1 * FROM tblSlotUser WHERE (IdUserNum=2) AND (IdPanel=1)
  42. SELECT * FROM ViewTimezoneReader WHERE (IdPanel=1) AND (IdAccessGroup=1)
  43. SELECT  cast(dest.text as varchar(8000))  FROM    sys.dm_exec_query_stats AS deqs          CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest  WHERE   deqs.last_execution_time > '5/23/2018 15:33'          /*AND dest.text LIKE 'UPDATE%';*/
  44. (@1 varchar(8000),@2 smallint)UPDATE [tblLogonServer] set [LastInLiveTime] = CONVERT([datetime],@1,(120))  WHERE [IdLogon]=@2
  45. (@IdNetwork int)DELETE FROM tblMassDownload WHERE bFailed=1 AND IdDownload IN (SELECT IdDownload FROM tblDownloadFailed WHERE IdNetwork=@IdNetwork);                                DELETE FROM tblDownloadFailed WHERE IdNetwork=@IdNetwork;
  46. (@IdNetwork int)DELETE FROM tblMassDownload WHERE bFailed=1 AND IdDownload IN (SELECT IdDownload FROM tblDownloadFailed WHERE IdNetwork=@IdNetwork);                                DELETE FROM tblDownloadFailed WHERE IdNetwork=@IdNetwork;
  47. SELECT  TOP 1 * FROM viewUserDetails WHERE EmpNumCompany=2
  48. SELECT DISTINCT iEmployeeNum FROM tblEmployees ORDER BY iEmployeeNum
  49. (@1 nvarchar(4000),@2 varchar(8000),@3 nvarchar(4000),@4 nvarchar(4000),@5 int,@6 nvarchar(4000),@7 int,@8 int)INSERT INTO [tblMessages]([tEvent],[dtDate],[tLocation],[tEventEng],[bIndex],[tOperator],[IdOperator],[bSucceed]) values(@1,CONVERT([datetime],@2,(120)),@3,@4,@5,@6,@7,@8)
  50. (@IdNetwork int,@eCommand int,@IdPanel int,@IdRecord int,@iPriority int,@iTemp1 int)DECLARE @idDownload bigint;  INSERT tblDownload (dtDate,IdNetwork,eCommand,IdPanel,IdRecord,iPriority,iTemp1) VALUES (GETDATE(),@IdNetwork,@eCommand,@IdPanel,@IdRecord,@iPriority,@iTemp1);  SELECT @idDownload = SCOPE_IDENTITY();  SELECT @idDownload;  
  51. (@iEmployeeNum int)DELETE FROM tblAutoOpen WHERE EmployeeID=@iEmployeeNum;                                      DELETE FROM tblAutoOpenReaders WHERE EmployeeID=@iEmployeeNum;
  52. (@iEmployeeNum int)DELETE FROM tblAutoOpen WHERE EmployeeID=@iEmployeeNum;                                      DELETE FROM tblAutoOpenReaders WHERE EmployeeID=@iEmployeeNum;
  53. SELECT IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1, STUFF((SELECT ',' + CONVERT(VARCHAR(50), IdInfo) FROM tblMassDownload WHERE tblMassDownload.IdDownload = tblDownload.IdDownload AND bFailed=0 FOR XML PATH('')), 1, 1, '') [IdInfos] FROM tblDownload WHERE IdNetwork=1 GROUP BY IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1 ORDER BY IdDownload
  54. SELECT COUNT(*) FROM tblDownload
  55. SELECT IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1, STUFF((SELECT ',' + CONVERT(VARCHAR(50), IdInfo) FROM tblMassDownload WHERE tblMassDownload.IdDownload = tblDownloadFailed.IdDownload AND bFailed=1 FOR XML PATH('')), 1, 1, '') [IdInfos] FROM tblDownloadFailed WHERE IdNetwork=1 GROUP BY IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1 ORDER BY IdDownload
  56. (@1 tinyint)SELECT * FROM [tblPanel] WHERE [IDPanel]=@1 ORDER BY [IdHardware] ASC
  57. (@1 nvarchar(4000),@2 varchar(8000),@3 nvarchar(4000),@4 nvarchar(4000),@5 int,@6 nvarchar(4000),@7 int)INSERT INTO [tblMessages]([tEvent],[dtDate],[tLocation],[tEventEng],[bIndex],[tOperator],[bSucceed]) values(@1,CONVERT([datetime],@2,(120)),@3,@4,@5,@6,@7)
  58. SELECT TOP 1 * FROM tblSlotCard WHERE (IdCardNum=2) AND (IdPanel=1)
  59. SELECT  TOP 1 * FROM viewUserDetails WHERE iEmployeeNum=2
  60. (@Ids nvarchar(1))SELECT CardId, CardAutomationId, dtShownDate FROM tblCardAutomationShown c INNER JOIN SplitArrayIDs(@Ids) arr ON c.CardId = arr.ArrayID
  61. (@1 tinyint)DELETE [tblSlotCard]  WHERE [IdCardNum]=@1
  62. SELECT TOP 1 * FROM tblPanel WHERE IdPanel=1 ORDER BY IdHardware
  63. (@IdPanel int)DELETE FROM tblMassDownload WHERE bFailed=1 AND IdDownload IN (SELECT IdDownload FROM tblDownloadFailed WHERE IdPanel=@IdPanel);                                DELETE FROM tblDownloadFailed WHERE IdPanel=@IdPanel;
  64. (@IdPanel int)DELETE FROM tblMassDownload WHERE bFailed=1 AND IdDownload IN (SELECT IdDownload FROM tblDownloadFailed WHERE IdPanel=@IdPanel);                                DELETE FROM tblDownloadFailed WHERE IdPanel=@IdPanel;
  65. SELECT IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1, STUFF((SELECT ',' + CONVERT(VARCHAR(50), IdInfo) FROM tblMassDownload WHERE tblMassDownload.IdDownload = tblDownload.IdDownload AND bFailed=0 FOR XML PATH('')), 1, 1, '') [IdInfos] FROM tblDownload WHERE IdPanel=1 GROUP BY IdDownload, IdPanel, IdNetwork, dtDate, eCommand, IdRecord, iPriority, iTemp1 ORDER BY IdDownload
  66. (@IdPanel int)DELETE FROM tblMassDownload WHERE bFailed=0 AND IdDownload IN (SELECT IdDownload FROM tblDownload WHERE IdPanel=@IdPanel);                                DELETE FROM tblDownload WHERE IdPanel=@IdPanel;
  67. (@IdPanel int)DELETE FROM tblMassDownload WHERE bFailed=0 AND IdDownload IN (SELECT IdDownload FROM tblDownload WHERE IdPanel=@IdPanel);                                DELETE FROM tblDownload WHERE IdPanel=@IdPanel;
  68. DELETE FROM tblMassDownload WHERE bFailed=0 AND IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloads);                        DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM ViewDownloadsUnattached);
  69. DELETE FROM tblMassDownload WHERE bFailed=0 AND IdMassDownload IN (SELECT IdMassDownload FROM ViewDuplicateDownloads);                        DELETE FROM tblDownload WHERE IdDownload IN (SELECT IdDownload FROM ViewDownloadsUnattached);
  70. (@1 int,@2 int,@3 nvarchar(4000),@4 nvarchar(4000),@5 nvarchar(4000),@6 int,@7 nvarchar(4000),@8 nvarchar(4000),@9 int,@10 int,@11 nvarchar(4000),@12 int,@13 int,@14 nvarchar(4000),@15 nvarchar(4000),@16 nvarchar(4000),@17 int,@18 nvarchar(4000),@19 int,@20 int,@21 nvarchar(4000),@22 int,@23 int,@24 nvarchar(4000),@25 int,@26 int,@27 varchar(8000),@28 varchar(8000),@29 int,@30 nvarchar(4000),@31 int,@32 nvarchar(4000),@33 nvarchar(4000),@34 nvarchar(4000),@35 nvarchar(4000),@36 varchar(8000),@37 nvarchar(4000),@38 int,@39 int,@40 varchar(8000),@41 int,@42 int,@43 nvarchar(4000),@44 int,@45 nvarchar(4000),@46 int,@47 int,@48 int,@49 int,@50 int,@51 int,@52 int,@53 nvarchar(4000))INSERT INTO [tblEmployees]([iCounter],[iVisitorEnableArea],[tEmailMsg],[tFax],[tMiddleName],[bColorB],[tPosition],[tLastName],[iEmployeeNum],[iAntipassbackImmunity],[tEmailAddress],[IdOutputsGroup],[wCardAndCardGroup],[tNotes],[tVisitorUser],[tIdentification],[bColorA],[tEmailTo],[bAccessDenied],[bHandicap],[tMobile],[bHLXArm],[wParkingSubGroup],[tCar],[bColorR],[bMasterUser],[dtStopDate],[dtStartDate],[bInterlockGroupImmunity],[tVisitorSpecialID],[IdDepartment],[tCodePINDuress],[tHomeTel],[tTel],[tPhotoFile],[tEmail],[dtVisitDateTime],[tEmailSubject],[IdAccessGroup],[eVisitorDisable],[dtEmpDate],[iVisitorDepartment],[bNewCounter],[tCodePIN],[IdTimeGroup],[tFirstName],[bExtended],[iVisitorUser],[bColorG],[EmpNumCompany],[bVisitDate],[bValidDate],[bEnabledCount],[tAddress]) values(@1,@2,@3,@4,@5,@6,@7,@8,@9,@10,@11,@12,@13,@14,@15,@16,@17,@18,@19,@20,@21,@22,@23,@24,@25,@26,CONVERT([datetime],@27,(120)),CONVERT([datetime],@28,(120)),@29,@30,@31,@32,@33,@34,NULL,@35,CONVERT([datetime],@36,(120)),@37,@38,@39,CONVERT([datetime],@40,(120)),@41,@42,@43,@44,@45,@46,@47,@48,@49,@50,@51,@52,@53)
  71. (@1 int,@2 int,@3 varchar(8000),@4 int,@5 int,@6 int)INSERT INTO [tblDownloadFailed]([IdRecord],[iTemp1],[dtDate],[IdNetwork],[eCommand],[IdPanel]) values(@1,@2,CONVERT([datetime],@3,(120)),@4,@5,@6)
  72. SELECT DISTINCT IdUserSlot FROM tblSlotUser WHERE IdPanel = 1 ORDER BY IdUserSlot
  73. SELECT DISTINCT EmpNumCompany FROM tblEmployees ORDER BY EmpNumCompany
  74. (@1 int,@2 int,@3 int)INSERT INTO [tblSlotUser]([IdUserSlot],[IdPanel],[IdUserNum]) values(@1,@2,@3)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!