[SQL]T-SQL LOCK Overviews

Ref:
WITH (NOLOCK)
http://blog.xuite.net/linriva/blog/39534686

LOCK Architecture
http://jackyshih.pixnet.net/blog/post/6154337-sql-server-lock-%E6%9E%B6%E6%A7%8B%E8%AE%80%E5%BE%8C%E5%BF%83%E5%BE%97

[SQL]Dynamic SQL table name or column name guide

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