ColdFusion Interview Question:

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

Submitted by: Administrator

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
Submitted by: Administrator