fatkun's blog

CREATE PROCEDURE update_createtime
@tbID INT
AS
    UPDATE t_member SET createTime = GetDate() WHERE tbID = @tbID
GO

--Developer:zhihui Zhou
--Date：New（）as 2008-10-18
--Email：zhou5791759@163.com
--QQ:297510342
 
CREATE PROCEDURE update_createtime
@tbID INT,
@createTime nvarchar(50) output
AS
    UPDATE t_member SET createTime = GetDate() WHERE tbID = @tbID
    SET @createTime = (SELECT createTime FROM t_member WHERE tbID = @tbID)
GO

--Call SQL in the method for
--start
DECLARE @createTime nvarchar(50)
EXEC update_createTime 1,@createTime output
--end