Hi All
Here i am facing problem with insert two table in store procedure
my Code is:
create proc [dbo].[Insert_StaffMaster_DeviceInfo_SP]
(
@UserIdN int,
@EmpCodeC nvarchar(15),
@empnamec varchar(50),
@deptcodec varchar(50),
@DesigCodeC varchar(50),
@seccodec varchar(50),
@Dojd smalldatetime,
@TerminateDateD smalldatetime,
@DOB smalldatetime,@CatgCodeC varchar(50),
@Gender nvarchar(1),@Photo nvarchar(255),
@LocationC nvarchar(150),@ShiftGroupCodeC varchar(10),
@NricWPNoC varchar(15),
@Privilege varchar(50),
@Password nvarchar(50),
@Enabled nvarchar(50),
@CardNumber nvarchar(MAX)
)
as
begin
if not exists(select UserIdN from StaffMaster where UserIdN=@UserIdN)
insert into StaffMaster (UserIdN,EmpCodeC,empnamec,deptcodec,DesigCodeC,seccodec,Dojd,TerminateDateD,DOB,CatgCodeC,Gender,Photo,LocationC,ShiftGroupCodeC,NricWPNoC) values (@UserIdN,@EmpCodeC,@empnamec,@deptcodec,@DesigCodeC,@seccodec,@Dojd,@TerminateDateD,@DOB,@CatgCodeC,@Gender,@Photo,@LocationC,@ShiftGroupCodeC,@NricWPNoC)
insert into Device_StaffFP(UserIDN,Privilege,Password,Enabled,CardNumber) values (@UserIDN,@Privilege,@Password,@Enabled,@CardNumber)
else
update StaffMaster set UserIdN=@UserIdN,EmpCodeC=@EmpCodeC,empnamec=@empnamec,deptcodec=@deptcodec,DesigCodeC=@DesigCodeC,seccodec=@seccodec,Dojd=@Dojd,TerminateDateD=@TerminateDateD,DOB=@DOB,CatgCodeC=@CatgCodeC,Gender=@Gender,Photo=@Photo,LocationC=@LocationC,ShiftGroupCodeC=@ShiftGroupCodeC,NricWPNoC=@NricWPNoC where UserIdN=@UserIdN
update Device_StaffFP set UserIDN=@UserIDN,Privilege=@Privilege,Password=@Password,Enabled=@Enabled,CardNumber=@CardNumber where UserIDN=@UserIDN
end
when i try this i got error that is,
Incorrect syntax near the keyword 'else'
.
and one more this shall i use this query for Updating ?
Thank You !