
数据库
yangzhenping
我坚信让我一往无前的唯一力量就是我热爱我所做的一切!
展开
-
08年帮同学写的文档,下载
http://download.youkuaiyun.com/source/2223067原创 2010-04-10 08:22:00 · 1424 阅读 · 0 评论 -
SQL SplitString function
/*while set ANSI_NULLS on, select * from table1 where column_name1=NULL will return 0 row, select * from table1 where column_name1NULL will return 0 row, no matter column_name1 contains null value or not.*/ /*while set ANSI_NULLS off, select * fr原创 2010-09-30 11:16:00 · 1846 阅读 · 0 评论 -
using try catch finally in SQL
<br />-- sorry, it looks so like the assemble language struct<br /> <br />-- when power not enough, or memory capacity not enough, or other reasons<br />delete from table1 where id='123456789'<br /><br />-- @@ERROR is a global error variable, it will err w原创 2010-10-20 15:25:00 · 2242 阅读 · 0 评论