Witam,
Mam taką tabele:
create procedure addReservation(@member_no int , @serial_no int , @remarks varchar(250))
as
begin
SET IDENTITY_INSERT dbo.Reservation ON
insert into reservation values ( @member_no , @serial_no , GETDATE() , @remarks)
end;
I taką procedure:
create procedure addReservation(@member_no int , @serial_no int , @remarks varchar(250))
as
begin
SET IDENTITY_INSERT dbo.Reservation ON
insert into reservation values ( @member_no , @serial_no , GETDATE() , @remarks)
end;
Wyskakuje mi taki błąd:
Msg 8101, Level 16, State 1, Procedure addReservation, Line 8
An explicit value for the identity column in table 'reservation' can only be specified when a column list is used and IDENTITY_INSERT is ON.
Jak sobie z tym poradzić?
Dziękuję