阅读背景:

MS SQL Server存储过程错误'语法不正确'

来源:互联网 

This is my stored procedure:

这是我的存储过程:

ALTER PROCEDURE its.sp_WriteTransaction

    (
    @LoginID int, 
    @PersonID int, 
    @BusinessID int, 
    @TransType smallint, 
    @LastHost varchar(15), 
    @TransData varchar(255)
)

AS

DECLARE @TransDate DATETIME
SET @TransDate = GETDATE()

INSERT INTO Transactions (LoginID, PersonID, BusinessID, TransDate, TransType, LastHost, TransData)
VALUES (@LoginID, @PersonID, @BusinessID, @TransDate, @TransType, @LastHost, @TransData) 
RETURN
ALTE



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: