archgeus zrewidował ten Gist . Przejdź do rewizji
Brak zmian
archgeus zrewidował ten Gist . Przejdź do rewizji
Brak zmian
archgeus zrewidował ten Gist . Przejdź do rewizji
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'363898') | |
| 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