月增量查询 [英] Month increment query

问题描述

我想通过添加 1 个月来更新我的数据库中的月份，但我不知道如何在我的以下存储过程查询中添加月份我不擅长 sql 请检查它

I want to update month in my database by adding 1 month but I don't know how I want to add month in my following stored procedure query I am not good in sql kindly check it

ALTER PROCEDURE [dbo].[ChangePassword] 

@password varchar(20),
@epassword varchar(50),
@username char(32)
AS
UPDATE AccountRole 
    SET Password = @password, 
        EPassword = @epassword 
    WHERE UserName = @username

    UPDATE AccountRole 
    SET ExpiryDate="?"

这里我要写什么来增加 1 个月的查询执行

Hhere what do I have to write to increment 1 month when query executes

推荐答案

要将 DATETIME 或 DATE 类型的现有值增加一个月，请使用:

To increment an existing value of type DATETIME or DATE by one month, use:

UPDATE AccountRole 
SET ExpiryDate = DATEADD(MONTH, 1, ExpiryDate)

并且正如 Oleg 正确指出的那样，假设您的两个 UPDATE 语句具有相同的 WHERE 条件(WHERE UserName = @username)，那么你可以在一个 UPDATE 中做到这一点:

and as Oleg rightfully pointed out, assuming that your two UPDATE statements have the same WHERE condition (WHERE UserName = @username), then you could do this in a single UPDATE:

UPDATE dbo.AccountRole 
SET Password = @password, 
    EPassword = @epassword,
    ExpiryDate = DATEADD(MONTH, 1, ExpiryDate)
WHERE UserName = @username

这篇关于月增量查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！