34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE PROC UP_HOUSE
@TITLE varchar(2000),
@TEL varchar(300)
AS
UPDATE dbo.INFO_HOUSE SET ADDTIME = GETDATE() , VALIDITY_DATE = DATEADD(Month,1,VALIDITY_DATE) WHERE TITLE = @TITLE AND TEL = @TEL
SELECT @@IDENTITY
EXEC UP_HOUSE '转让','15114551047'
UPDATE dbo.INFO_HOUSE SET ADDTIME = GETDATE() , VALIDITY_DATE = DATEADD(Month,1,VALIDITY_DATE)
WHERE TITLE = '转让' AND TEL = '15114551047'