存储过程中的错误 [英] Error in Stored Procedury
本文介绍了存储过程中的错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好
我正在执行SP而且我在这3列中有一个表有数据类型作为日期时间所以当我执行SP然后我得到这样的错误
消息102,等级15,状态1,行19
' - '附近的语法不正确。
任何人都可以帮助我
thnxxx
Hi guys
I am Executing SP and I have one table in among of that 3 columns have datatype as a datetime so when i am Execute SP then i get an error like this
Msg 102, Level 15, State 1, Line 19
Incorrect syntax near '-'.
anybody can help me
thnxxx
推荐答案
创建PROCEDURE [dbo]。[INSERT_DSE ]
@DSE_FirstName varchar(50),
@DSE_LastName varchar(50),>
@DSE_MiddleName varchar(50),
@DSE_EmployeeID varchar(20),
@Address varchar(MAX),
@MobileNo int,
@Photo binary(50),
@PhotoID_Type varchar(50),
@PhotoID_No varchar(50),
@JoiningDate datetime,
@LeavingDate datetime,
@CreatedBy varchar(50),
@UpdatedBy varchar( 50),
@AreaID int,
@RouteID int,
@ProductI D int,
@StockID int,
@UserID int,
@MSG VARCHAR(10)OUT
- )
AS
BEGIN
开始尝试
插入DSE_Info
VALUES(
@DSE_FirstName,
@DSE_LastName,
@DSE_MiddleName,
@DSE_EmployeeID,
@Address,
@MobileNo,
@Photo,
@PhotoID_Type,
@PhotoID_No,
@JoiningDate,
@LeavingDate,
1,
@ CreatedBy,
GETDATE(),
@UpdatedBy,
GETDATE(),
@AreaID,
@RouteID,
@ProductID,
@StockID,
@UserID
< br $>
)
SET @ MSG ='成功'
结束尝试
BEGIN CATCH
SET @MSG ='失败'
E. ND CATCH
结束
试试这个
create PROCEDURE [dbo].[INSERT_DSE]
@DSE_FirstName varchar(50),
@DSE_LastName varchar(50),
@DSE_MiddleName varchar(50),
@DSE_EmployeeID varchar(20),
@Address varchar(MAX),
@MobileNo int,
@Photo binary(50),
@PhotoID_Type varchar(50),
@PhotoID_No varchar(50),
@JoiningDate datetime,
@LeavingDate datetime,
@CreatedBy varchar(50),
@UpdatedBy varchar(50),
@AreaID int,
@RouteID int,
@ProductID int,
@StockID int,
@UserID int,
@MSG VARCHAR(10) OUT
-- )
AS
BEGIN
BEGIN TRY
INSERT INTO DSE_Info
VALUES (
@DSE_FirstName,
@DSE_LastName,
@DSE_MiddleName,
@DSE_EmployeeID,
@Address,
@MobileNo,
@Photo,
@PhotoID_Type,
@PhotoID_No,
@JoiningDate,
@LeavingDate,
1,
@CreatedBy,
GETDATE(),
@UpdatedBy,
GETDATE(),
@AreaID,
@RouteID,
@ProductID,
@StockID,
@UserID
)
SET @MSG='SUCCESS'
END TRY
BEGIN CATCH
SET @MSG = 'FAILED'
END CATCH
END
try this
这篇关于存储过程中的错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文