tasklist_updateusernotification.sql

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

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

CREATE PROCEDURE TaskList_UpdateUserNotification
	@Username VarChar(20),
  @PasswordHash VarChar(50),
  @ShouldNotify bit,
  @NotifyPeriod BigInt
AS

UPDATE TaskListUsers SET ShouldNotify = @ShouldNotify, NotifyPeriod = @NotifyPeriod, LastNotified = GetDate()
WHERE Username = @Username AND PasswordHash = @PasswordHash;