tasklist_updatenotificationemail.sql

来自「一个采用VS2008+Sql2000开发的任务管理系统」· SQL 代码 · 共 31 行

-- =============================================
-- TaskList_UpdateNotificationEmail
-- =============================================
-- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = N'TaskList_UpdateNotificationEmail' 
	   AND 	  type = 'P')
    DROP PROCEDURE TaskList_UpdateNotificationEmail
GO

CREATE PROCEDURE TaskList_UpdateNotificationEmail
	@Username VarChar(20),
  @PasswordHash VarChar(50),
  @NotificationEmail VarChar(5000)
AS
DECLARE @UserID BigInt

SELECT @UserID = ID FROM TaskListUsers WHERE
  Username = @Username AND PasswordHash = @PasswordHash AND IsAdministrator = 1

IF @UserID > 0
BEGIN
  DELETE FROM TaskListNotification;
  INSERT INTO TaskListNotification
  (NotificationEmail)
  VALUES
  (@NotificationEmail)
  END
ELSE
  Return(-1);