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: AdministratorSET 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
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
Read Online ColdFusion Job Interview Questions And Answers
Top ColdFusion Questions
| ☺ | How can you communicate with web server (Apache or IIS) from Coldfusion? |
| ☺ | What are Session Timeout and Application Timeout? Where we have to do this process? |
| ☺ | Difference between Cold fusion MX 6 and Cold fusion MX 7? |
| ☺ | What is Application Server? |
| ☺ | Compare Cold fusion with other programming languages? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
