Ref:
http://colinmackay.scot/2009/09/21/if-you-really-must-do-dynamic-sql/
Other Relative Ref:
- Specify output parameters when use the sp_executesql
https://support.microsoft.com/en-us/kb/262499
sp_executesqsp_executesqllsp_executesql sp_executesql
