CollectionDB.sql
· 1.0 KiB · MySQL
Ham
-- ------------------------------ Table structure for DbInfo-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U'))
DROP TABLE [dbo].[DbInfo]
GO
CREATE TABLE [dbo].[DbInfo] ( [version] int NULL)
GO
ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE)
GO
-- ------------------------------ Records of DbInfo-- ----------------------------
INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'368275')
GO
-- ------------------------------ procedure structure for spGetPlanetDatabaseVersion-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetPlanetDatabaseVersion]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF'))
DROP PROCEDURE[dbo].[spGetPlanetDatabaseVersion]
GO
CREATE PROCEDURE [dbo].[spGetPlanetDatabaseVersion]
AS
BEGIN
BEGIN TRY
BEGIN TRAN
SELECT version FROM DbInfo
END TRY
BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
print ERROR_MESSAGE()
END CATCH
IF @@TRANCOUNT > 0
COMMIT TRANSACTION
END
| 1 | -- ------------------------------ Table structure for DbInfo-- ---------------------------- |
| 2 | |
| 3 | IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[DbInfo]') AND type IN ('U')) |
| 4 | |
| 5 | DROP TABLE [dbo].[DbInfo] |
| 6 | |
| 7 | GO |
| 8 | |
| 9 | CREATE TABLE [dbo].[DbInfo] ( [version] int NULL) |
| 10 | |
| 11 | GO |
| 12 | |
| 13 | ALTER TABLE [dbo].[DbInfo] SET (LOCK_ESCALATION = TABLE) |
| 14 | |
| 15 | GO |
| 16 | |
| 17 | -- ------------------------------ Records of DbInfo-- ---------------------------- |
| 18 | |
| 19 | INSERT INTO [dbo].[DbInfo] ([version]) VALUES (N'368275') |
| 20 | |
| 21 | GO |
| 22 | |
| 23 | -- ------------------------------ procedure structure for spGetPlanetDatabaseVersion-- ---------------------------- |
| 24 | |
| 25 | IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[spGetPlanetDatabaseVersion]') AND type IN ('FN', 'FS', 'FT', 'IF', 'TF')) |
| 26 | |
| 27 | DROP PROCEDURE[dbo].[spGetPlanetDatabaseVersion] |
| 28 | |
| 29 | GO |
| 30 | |
| 31 | CREATE PROCEDURE [dbo].[spGetPlanetDatabaseVersion] |
| 32 | AS |
| 33 | BEGIN |
| 34 | BEGIN TRY |
| 35 | BEGIN TRAN |
| 36 | SELECT version FROM DbInfo |
| 37 | END TRY |
| 38 | BEGIN CATCH |
| 39 | IF @@TRANCOUNT > 0 |
| 40 | ROLLBACK TRANSACTION |
| 41 | print ERROR_MESSAGE() |
| 42 | END CATCH |
| 43 | IF @@TRANCOUNT > 0 |
| 44 | COMMIT TRANSACTION |
| 45 | END |