Sat, 02 Feb 2008 17:39:00 GMThttp://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071085/1184513/1/item.htmlcomments/2078790.aspx0comments/commentRss/2078790.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=2078790跟踪一个表的所有操作的触发器 <img src ="aggbug/2078790.aspx" width = "1" height = "1" />Sun, 03 Feb 2008 01:39:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2008/02/02/2078790.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2008/02/02/2078790.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2008/02/02/2078790.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071085/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071087/1184513/1/item.htmlcomments/1738175.aspx0comments/commentRss/1738175.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1738175又见火车票问题<img src ="aggbug/1738175.aspx" width = "1" height = "1" />Sat, 11 Aug 2007 23:25:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/08/11/1738175.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/08/11/1738175.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/08/11/1738175.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071087/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071094/1184513/1/item.htmlcomments/1717206.aspx2comments/commentRss/1717206.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1717206通过一个例子说明在编写Sql Server 触发器代码时应该注意的几个方面，以及防止无限递归触发器发生的方法。 <img src ="aggbug/1717206.aspx" width = "1" height = "1" />Tue, 31 Jul 2007 04:12:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/30/1717206.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/30/1717206.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/30/1717206.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071094/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071097/1184513/1/item.htmlcomments/1711561.aspx0comments/commentRss/1711561.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1711561自定义函数查找相似记录和计算相似度<img src ="aggbug/1711561.aspx" width = "1" height = "1" />Fri, 27 Jul 2007 23:30:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711561.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711561.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711561.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071097/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071101/1184513/1/item.htmlcomments/1711398.aspx0comments/commentRss/1711398.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1711398一个典型的Sql Server 触发器应用，根据用户表的插入、删除、修改同时修改部门表的人数。<img src ="aggbug/1711398.aspx" width = "1" height = "1" />Fri, 27 Jul 2007 21:50:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711398.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711398.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/27/1711398.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071101/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071105/1184513/1/item.htmlcomments/1707219.aspx1comments/commentRss/1707219.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=17072190<img src ="aggbug/1707219.aspx" width = "1" height = "1" />Wed, 25 Jul 2007 22:10:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1707219.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1707219.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1707219.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071105/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071107/1184513/1/item.htmlcomments/1706819.aspx1comments/commentRss/1706819.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1706819触发器和作业结合，完成一些定时操作的功能。<img src ="aggbug/1706819.aspx" width = "1" height = "1" />Wed, 25 Jul 2007 18:09:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1706819.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1706819.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/25/1706819.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071107/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071109/1184513/1/item.htmlcomments/1702918.aspx0comments/commentRss/1702918.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1702918自定义函数实现字符串中数据的运算和统计<img src ="aggbug/1702918.aspx" width = "1" height = "1" />Mon, 23 Jul 2007 22:18:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702918.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702918.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702918.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071109/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071110/1184513/1/item.htmlcomments/1702626.aspx0comments/commentRss/1702626.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1702626自定义函数实现字符串中数据的运算和统计。<img src ="aggbug/1702626.aspx" width = "1" height = "1" />Mon, 23 Jul 2007 19:06:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702626.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702626.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/23/1702626.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071110/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071111/1184513/1/item.htmlcomments/1701476.aspx0comments/commentRss/1701476.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1701476两个事例说明自定义函数实现位操作的应用。<img src ="aggbug/1701476.aspx" width = "1" height = "1" />Sun, 22 Jul 2007 00:35:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701476.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701476.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701476.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071111/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071112/1184513/1/item.htmlcomments/1701421.aspx0comments/commentRss/1701421.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1701421j9988写的《破解SQLSERVER 2000的加密函数,过程,触发器,视图的存储过程》使大家都受益匪浅，但是那个存储过程并不能适用于6.5版，由于本人前几年还在使用6.5版，参考j9988的过程，查了部分资料，写了这个6.5版的解密存储过程。但是遗憾的是，一旦原有存储过程中出现中文，这个解密存储过程就不能工作，我也一直没有解决这个问题，也一直没敢拿出来，现在估计6.5的用户已经很少，我也没有条件再完善了，放出来给需要的人作个参考吧。 <img src ="aggbug/1701421.aspx" width = "1" height = "1" />Sat, 21 Jul 2007 23:32:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701421.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701421.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701421.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071112/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071114/1184513/1/item.htmlcomments/1701408.aspx0comments/commentRss/1701408.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1701408写了几个数制转换的自定义函数，综合起来实现16进制浮点数转化成10进制的功能。 <img src ="aggbug/1701408.aspx" width = "1" height = "1" />Sat, 21 Jul 2007 23:14:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701408.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701408.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701408.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071114/1184513http://item.feedsky.com/~csdn.net/Haiwer/~1184532/48071115/1184513/1/item.htmlcomments/1701394.aspx0comments/commentRss/1701394.aspxhttp://tb.blog.csdn.net/TrackBack.aspx?PostId=1701394用SQL语言实现显示杨辉三角，使用了动态修改的临时表。<img src ="aggbug/1701394.aspx" width = "1" height = "1" />Sat, 21 Jul 2007 22:58:00 +0800Haiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701394.aspx#Feedbackhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701394.aspxHaiwerhttp://blog.csdn.net/Haiwer/archive/2007/07/21/1701394.aspxhttp://blog.csdn.net/Haiwer/rss.aspxcsdn.net/Haiwer/~1184532/48071115/1184513