|
Server : Apache/2.4.43 (Win64) OpenSSL/1.1.1g PHP/7.4.6 System : Windows NT USER-PC 6.1 build 7601 (Windows 7 Professional Edition Service Pack 1) AMD64 User : User ( 0) PHP Version : 7.4.6 Disable Function : NONE Directory : C:/Windows/Microsoft.NET/Framework64/v4.0.30319/SQL/en/ |
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- -- DeleteInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[DeleteInstance] GO -- -- LoadInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LoadInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[LoadInstance] GO -- -- LockInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LockInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[LockInstance] GO -- -- InsertInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[InsertInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[InsertInstance] GO -- -- UpdateInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UpdateInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[UpdateInstance] GO -- -- UnlockInstance -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UnlockInstance]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[UnlockInstance] GO