line 18 is getting error near ''this codes(mysql)
-
ALTER procedure [dbo].[sp_BankInsert] ( @bankid varchar(100), @bankname varchar(100), @address1 varchar(100), @address2 varchar(100), @city varchar(50), @state varchar(100), @country varchar(50), @telephone1 varchar(20), @telephone2 varchar(20), @fax varchar(20), @email varchar(50), @contactperson varchar(100), @cphone varchar(20) ) begin insert into tblBankMaster(bankid,bankname,address1,address2,city,state, country,telephone1,telephone2,fax,email,contactperson,cphone)values('@bankid', '@bankname','@address1','@address2','@city','@state','@country','@telephone1', '@telephone2','@fax','@email','@contactperson','@cphone'); end
smar
-
ALTER procedure [dbo].[sp_BankInsert] ( @bankid varchar(100), @bankname varchar(100), @address1 varchar(100), @address2 varchar(100), @city varchar(50), @state varchar(100), @country varchar(50), @telephone1 varchar(20), @telephone2 varchar(20), @fax varchar(20), @email varchar(50), @contactperson varchar(100), @cphone varchar(20) ) begin insert into tblBankMaster(bankid,bankname,address1,address2,city,state, country,telephone1,telephone2,fax,email,contactperson,cphone)values('@bankid', '@bankname','@address1','@address2','@city','@state','@country','@telephone1', '@telephone2','@fax','@email','@contactperson','@cphone'); end
smar
Remove the ': should look like: values(@bankid, etc.