Rewizja CollectionDB Procedure

1 file changed, 0 insertions, 0 deletions

gistfile1.txt zmieniono nazwę na CollectionDB.sql

Zmieniono nazwę pliku bez modyfikacji zawartości

1 file changed, 45 insertions

gistfile1.txt(stworzono plik)

		@@ -0,0 +1,45 @@
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

Nowsze Starsze