> > >

Microsoft Azure MCQs

ln SQL Azure, which of the following is the correct syntax of the stored procedure
"sp_execute_remote"?

sp_execute_remote [@data_source_name = ] datasourcename

[

{ . [ @params =] N‘@parameter_name data_type [,...n ]‘]

{ .[@param1=] 'value1' [....n]}

[. @Stmt = ] statement

]

sp_execute_remote [ . @stmt = ] statement

[@data_source_name =] datasourcename

[

{ , [ @params =] N‘@parameter_name data_type [,...n ]']

( .[@param1 =] 'value1' [....n]}

]

sp_execute_remote [@data_source_name = ] datasourcename

[. @Stmt = ] statement

[ . [ @params =] N'@parameter_narne data_type [,...n T]

[,[@param1=]'value1'[,...n]]

]

Answer

Correct Answer:

sp_execute_remote [@data_source_name = ] datasourcename

[. @Stmt = ] statement

[ . [ @params =] N'@parameter_narne data_type [,...n T]

[,[@param1=]'value1'[,...n]]

]

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Microsoft Azure Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it