Answers

Question and Answer:

  Home  ColdFusion

⟩ How would you write a simple stored procedure in TSQL which takes a movie_id and returns all the directors associated with it?

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE procedure [dbo].getDirector (

@movie_id INT

)

SELECT name FROM directors WHERE movie_id = @movie_id

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

 153 views

More Questions for you: