I m creating the stored Procedure in SQL.
Create Procedure submitrecord
{
@ID varchar(10),
@Password varchar(10),
@EMailID varchar(50)
}
AS INsert into login(ID1,Password1,EMailID)values(@ID,@Password,@EMailID)
GO
I m getting the error
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation
|
| Author: dom 04 Nov 2009 | Member Level: Silver | Rating:  Points: 2 |
Create Procedure submitrecord
@ID varchar(10),
@Password varchar(10),
@EMailID varchar(50)
AS
BEGIN
INsert into login(ID1,Password1,EMailID)values(@ID,@Password,@EMailID)END
......This would help u
RATE THIS ANS
|
| Author: Sonia sardana 04 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
Getting the same error frnd
|
| Author: ABitSmart 04 Nov 2009 | Member Level: Diamond | Rating: Points: 2 |
Try this,
Create Procedure dbo.submitrecord
{
@ID varchar(10),
@Password varchar(10),
@EMailID varchar(50)
}
AS INsert into dbo.[login](ID1,Password1,EMailID)values(@ID,@Password,@EMailID)
GO
login is a reserved SQL keyword, it might be the problem.
|
| Author: Nagarajan 04 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
Create Procedure Sp_SubmitCard
@ID varchar(10),
@Password varchar(10),
@Email varchar(50)
as
Insert into tbl_login values(@ID,@Password,@Email)
Try this.. this 'll helpful to you
Regards,
Naresh
Don't Scream for a Change... Become a Change..
Do not forget to Rate the post..
|