کامروا
سه شنبه 19 اردیبهشت 1391, 00:10 صبح
سلام
میخوام Stored proc زیر درست کنم:
CREATE PROCEDURE save_user
@id VARCHAR(50)
@name VARCHAR(50)
@lname VARCHAR(50)
AS
IF LTRIM(RTRIM(@id))<>''
BEGIN
INSERT INTO user VALUES(id=@id,name=@name)
END
اما خطای زیر رو میده:
Query: CREATE PROCEDURE save_user @id VARCHAR(50) @name VARCHAR(50) @lname VARCHAR(50) AS IF LTRIM(RTRIM(@id))<>'' BEGIN INSERT INTO us...
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@id VARCHAR(50)
@name VARCHAR(50)
@lname VARCHAR(50)
AS
IF LTRIM(RTRIM(@id))<>''' at line 2
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.001 sec
---------------------------------------------------
مشکل کجاست؟
مرسی
میخوام Stored proc زیر درست کنم:
CREATE PROCEDURE save_user
@id VARCHAR(50)
@name VARCHAR(50)
@lname VARCHAR(50)
AS
IF LTRIM(RTRIM(@id))<>''
BEGIN
INSERT INTO user VALUES(id=@id,name=@name)
END
اما خطای زیر رو میده:
Query: CREATE PROCEDURE save_user @id VARCHAR(50) @name VARCHAR(50) @lname VARCHAR(50) AS IF LTRIM(RTRIM(@id))<>'' BEGIN INSERT INTO us...
Error Code: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@id VARCHAR(50)
@name VARCHAR(50)
@lname VARCHAR(50)
AS
IF LTRIM(RTRIM(@id))<>''' at line 2
Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.001 sec
---------------------------------------------------
مشکل کجاست؟
مرسی