Select from following answers:- By using exec command.
- By using execute command.
- By using sp_executesql command.
- All of the above.
- All Above
By using above all options,we can execute Dynamic Stored Procedure.
For Example:-
declare @sql nvarchar(max);
set @sql = N'select * from test1';
exec(@sql);
OR
execute(@sql);
OR
execute sp_executesql @sql;
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator