USE [Test_DataBaseNew]
GO
ALTER PROCEDURE [dbo].[InsertMovies]
@MovieID int,
@MovieName nvarchar(50),
@Director nvarchar(50),
@dt As Movies_Actor readonly
-- @dt as MoviesActor readonly
AS
BEGIN
insert into Movies (MovieName, Director, MovieID) values(@MovieName, @Director, @MovieID)
insert MovieDetails (MovieID, ActorID )
select MovieID, ActorID from @dt
END