摘要:ref:http://blog.csdn.net/wym3587/article/details/6940630ref:http://www.cnblogs.com/jiajiayuan/archive/2011/07/13/2105398.html当 SET XACT_ABORT 为 OFF 时,... 阅读全文
with CTE AS
2015-05-06 14:37 by Purplez, 131 阅读, 0 推荐, 收藏,
摘要:CTE/表变量/Temphttp://www.cnblogs.com/ziyeyimeng/articles/2366855.html 阅读全文
Cursor use
2015-04-21 18:57 by Purplez, 180 阅读, 0 推荐, 收藏,
摘要:Ref:http://www.cnblogs.com/Gavinzhao/archive/2010/07/14/1777644.htmldeclare @Id varchar(100),@name varchar(10)declare ccursor cursor for select MAXID,... 阅读全文
post- build event
2015-04-21 17:22 by Purplez, 694 阅读, 0 推荐, 收藏,
摘要:Ref:http://blog.csdn.net/teng_ontheway/article/details/8307410Ref: http://blog.csdn.net/sodickbird/article/details/4826068需求:需求:可能我们需要给美工发布一个版本,那就需要*.... 阅读全文
sp_executesql
2015-04-08 11:42 by Purplez, 135 阅读, 0 推荐, 收藏,
摘要:execute相信大家都用的用熟了,简写为exec,除了用来执行存储过程,一般都用来执行动态Sqlsp_executesql,sql2005中引入的新的系统存储过程,也是用来处理动态sql的, 如:exec sp_executesql @sql, N'@count int out,@id varch... 阅读全文