CREATE PROCEDURE EditMyPassword
@inID nvarchar (8),
@inpassword nvarchar(30)
AS
UPDATE IDInfo
SET MemberPW = @inpassword
	FROM IDInfo ii JOIN ExpiryDates ed
	ON ii.MemberID = ed.MemberID 
	WHERE ii.MemberID=@inID AND 
	ed.ExpiryDate >= GETDATE()

Поделитесь материалом с коллегами и друзьями