diff options
| author | Badlop <badlop@process-one.net> | 2011-04-14 23:11:37 +0200 |
|---|---|---|
| committer | Badlop <badlop@process-one.net> | 2011-04-14 23:11:37 +0200 |
| commit | 4f1ececbd17cdc6ff19a42d5c7cacb32744800c7 (patch) | |
| tree | 64565ea53074e8d481a0cace8c9877e7426b36f8 /src/odbc/mssql2000.sql | |
| parent | The responses to HEAD must have empty Body (diff) | |
Try to improve support for roster_version in MSSQL (EJAB-1437)
Diffstat (limited to '')
| -rw-r--r-- | src/odbc/mssql2000.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/src/odbc/mssql2000.sql b/src/odbc/mssql2000.sql index 151d474a..d4a70989 100644 --- a/src/odbc/mssql2000.sql +++ b/src/odbc/mssql2000.sql @@ -597,6 +597,40 @@ BEGIN END
GO
+/******************************************************************/
+/****** Object: StoredProcedure [dbo].[set_roster_version] **/
+/** Update users roster_version **/
+/******************************************************************/
+CREATE PROCEDURE [dbo].[set_roster_version]
+ @Username varchar(200),
+ @Version varchar(50)
+AS
+BEGIN
+ IF EXISTS (SELECT username FROM roster_version WITH (NOLOCK) WHERE username=@Username)
+ BEGIN
+ UPDATE roster_version SET username=@Username, version=@Version WHERE username=@Username;
+ END
+ ELSE
+ BEGIN
+ INSERT INTO roster_version (username, version) VALUES (@Username, @Version);
+ END
+END
+GO
+
+/******************************************************************/
+/****** Object: StoredProcedure [dbo].[get_roster_version] **/
+/** Retrive the user roster_version **/
+/******************************************************************/
+CREATE PROCEDURE [dbo].[get_roster_version]
+ @Username varchar(200)
+AS
+BEGIN
+ SELECT roster_version.version as version
+ FROM roster_version WITH (NOLOCK)
+ WHERE username=@Username;
+END
+GO
+
/***************************************************************/
/****** Object: StoredProcedure [dbo].[clean_spool_msg] ******/
/** Delete messages older that 3 days from spool **/
|