hi
i wrote this procedure for insert to database
ALTER procedure [dbo].[Fileup1]
@image nvarchar(30),
@BehCode nvarchar(10)
as
begin
insert into House_p (Image)
values (@image)
where Behcode=@Behcode
end
but this error occur
Msg 156, Level 15, State 1, Procedure Fileup1, Line 9
Incorrect syntax near the keyword 'where'.
so what should i do?
Thanks