Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to execute Dynamic Stored Procedure or Dynamic Queries?
on 1/2/2015 | Category:
Sql Server Interview questions
| Views: 1010 |
Select from following answers:
By using exec command.
By using execute command.
By using sp_executesql command.
All of the above.
By using above all options,we can execute Dynamic Stored Procedure.
declare @sql nvarchar(max);
set @sql = N'select * from test1';
execute sp_executesql @sql;
Show Correct Answer
Many Interviews |
< Previous :
Which statement is correct concerning Primary Key?
Next > :
Which statement(s) is/are correct about Web Servic ...
Comments or Responses
Login to post response
More Interview Questions by vishalneeraj-24503
Which statement(s) is/are correct about Web Services?
Which statement(s) is/are correct about WCF?
What is the exact use of Logical Tables in Sql Server?
Which statement is/are correct about Static keyword?
Which statement is/are correct about ReadOnly?
Which statement is/are correct about Constant?
Which is the correct way to get Controls object in jQuery?
What is the output of below query? select * from test1 t1 inner join ...
Latest Interview Questions
How to check if a particular section in defined in the view page?
How to render a optional section in the _Layout page
How to know whether a request is a child request in normal action meth ...
How to prevent a browser from calling an action method of MVC?
You are learning, how to create window 8 store application using html5 ...
Which of the following VS studio versions you can used for create web ...
How to create table format in HTML ?
Difference between NameSpace and Assembly