http://wghao.itpub.net Mon,22 03 2010 15:36:36 http://www.plogworld.net 修改以前写的一个字符串分割自定义函数出现的bug.今天博客园中看到一朋友写的SQL中分割字符串函数：http://www.cnblogs.com/czwand/archive/2007/11/21/966910.html在回帖中看到一朋友说到：select * from dbo.split('01__02__03','__')发生错误，返回的结果不是我们原本要的结果：---------------------想要的结果010203-------------------实际结果：01_02_03以前我也写过类似的字符串分割自定义函数，也没有想过上面出现的这样问题。我原来的函数是这样的：/*StringToTable*/CREATE FUNCTION StringToTable(@StringX varchar(8000),@Sp... http://wghao.itpub.net/post/22404/424008 http://wghao.itpub.net/post/22404/424008 http://wghao.itpub.net/post/22404/424008 wghao SQL 2000 Mon,03 12 2007 14:37:29 OK_008 blog 今天一朋友在网上问一条特殊的含有"["和"]"的LIKE语句。这里简单整理测试一下LIKE语句对于"["和"]"的应用。CREATE TABLE #T(x nvarchar(400))INSERT INTO #TSELECT '[werx]' UNION ALLSELECT '[sd[]]' UNION ALLSELECT '[[sdf]]' UNION ALLSELECT '[img]sdfds[/img]' UNION ALLSELECT '[img]/img]]' UNION ALLSELECT 'img]/img]]' UNION ALLSELECT '[wsd]' --我们要查询格式为"[img]内容[/img]"的行SELECT * FROM #T WHERE x LIKE '%[img]%[/img]%'/*结果：-------------------[img]sdfds[/img][img]/img]]img]/img]]*/SELECT * FROM #T W... http://wghao.itpub.net/post/22404/414447 http://wghao.itpub.net/post/22404/414447 http://wghao.itpub.net/post/22404/414447 wghao SQL 2000 Tue,20 11 2007 12:59:23 OK_008 blog 上次学习了查看磁盘空间的命令df,昨天再学习了du的命令，现在记录一下学习过程。先man du查看du命令的说明：du - estimate file space usage SYNOPSIS du [OPTION] [FILE]DESCRIPTION Summarize disk usage of each FILE, recursively for directories. Mandatory arguments to long options are mandatory for short options too. -a, --all write counts for all files, not just directories --apparent-size print apparent sizes, rather than disk usage; although the apparent size is usually smaller, it may be larger due to ... http://wghao.itpub.net/post/22404/413774 http://wghao.itpub.net/post/22404/413774 http://wghao.itpub.net/post/22404/413774 wghao Linux/Unix Fri,16 11 2007 09:55:54 OK_008 blog 上次学习了查看磁盘空间的命令df,昨天再学习了du的命令，现在记录一下学习过程。先man du查看du命令的说明：du - estimate file space usage SYNOPSIS du [OPTION] [FILE]DESCRIPTION Summarize disk usage of each FILE, recursively for directories. Mandatory arguments to long options are mandatory for short options too. -a, --all write counts for all files, not just directories --apparent-size print apparent sizes, rather than disk usage; although the apparent size is usually smaller, it may be larger due to ... http://wghao.itpub.net/post/22404/413775 http://wghao.itpub.net/post/22404/413775 http://wghao.itpub.net/post/22404/413775 wghao Linux/Unix Fri,16 11 2007 09:55:39 OK_008 blog 上次学习了查看磁盘空间的命令df,昨天再学习了du的命令，现在记录一下学习过程。先man du查看du命令的说明：du - estimate file space usage SYNOPSIS du [OPTION] [FILE]DESCRIPTION Summarize disk usage of each FILE, recursively for directories. Mandatory arguments to long options are mandatory for short options too. -a, --all write counts for all files, not just directories --apparent-size print apparent sizes, rather than disk usage; although the apparent size is usually smaller, it may be larger due to ... http://wghao.itpub.net/post/22404/413771 http://wghao.itpub.net/post/22404/413771 http://wghao.itpub.net/post/22404/413771 wghao Linux/Unix Fri,16 11 2007 09:55:13 OK_008 blog 虽然不能把每一学习点都记录下来，但能记录的尽量记录，以方便以后查看自己的学习方法和对其总结。今天的主要目的是学习怎么样检查系统磁盘空间的使用情况。使用到的是df命令。先看一下df命令的说明： df - report filesystem disk space usageSYNOPSIS df [OPTION]... [FILE]...DESCRIPTION This manual page documents the GNU version of df. df displays the amount of disk space available on the filesystem containing each file name argument. If no file name is given, the space available on all currently mounted filesys... http://wghao.itpub.net/post/22404/413765 http://wghao.itpub.net/post/22404/413765 http://wghao.itpub.net/post/22404/413765 wghao Linux/Unix Fri,16 11 2007 09:41:41 OK_008 blog 现在学习Linux，做个学习笔记记录一下学习的过程。本次主要是学习建立目录和删除目录。建立文件目录如建立名叫ok_008的文件目录：[root@CentOS4 ~]# mkdir ok_008再建立一个多级目录：ok_008/ok/008[root@CentOS4 ~]# mkdir ok_008/ok/008mkdir: cannot create directory `ok_008/ok/008': No such file or directory[root@CentOS4 ~]#上面的命令是错误的。只有看看帮助了。[root@CentOS4 ~]# man mkdir说到-p, --parents no error if existing, make parent directories as neede建立多级目录的时候必须使用参数-p.正确的方法：[root@Cen... http://wghao.itpub.net/post/22404/413536 http://wghao.itpub.net/post/22404/413536 http://wghao.itpub.net/post/22404/413536 wghao Linux/Unix Wed,14 11 2007 18:05:43 OK_008 blog 本次主要是学习建立目录和删除目录。建立文件目录如建立名叫ok_008的文件目录：[root@CentOS4 ~]# mkdir ok_008再建立一个多级目录：ok_008/ok/008[root@CentOS4 ~]# mkdir ok_008/ok/008mkdir: cannot create directory `ok_008/ok/008': No such file or directory[root@CentOS4 ~]#上面的命令是错误的。只有看看帮助了。[root@CentOS4 ~]# man mkdir说到-p, --parents no error if existing, make parent directories as neede建立多级目录的时候必须使用参数-p.正确的方法：[root@CentOS4 ~]# mkdir -p ok_008/ok/008检查建立是否成功... http://wghao.itpub.net/post/22404/413537 http://wghao.itpub.net/post/22404/413537 http://wghao.itpub.net/post/22404/413537 wghao 其他 Wed,14 11 2007 18:05:41 OK_008 blog 今天上CSDN社区的时候，发现这帖子，感觉顶有意思，就想一下写出一解决方法。这里顺便记录自己的解决方法。原来问题：请问一下，在SQL中怎么来做可以快速生成1千万个9位英文（大写）随机不重复的号码，非常着急，谢谢啦。自己写的一个解决方法：DECLARE @i int CREATE TABLE #AZ(X nchar(1))SET @i=65WHILE @i<=90BEGININSERT INTO #AZ SELECT CHAR(@i)SET @i=@i+1ENDSELECT TOP 10000000 A.X+B.X+C.X+D.X+E.X+F.X+G.X+.H.X+I.X AS X INTO #T1FROM (SELECT TOP 32 X FROM #AZ ORDER BY NEWID()DESC) AS A,(SELECT TOP 32 X FROM #AZ ORDER... http://wghao.itpub.net/post/22404/295064 http://wghao.itpub.net/post/22404/295064 http://wghao.itpub.net/post/22404/295064 wghao SQL 2000 Fri,15 06 2007 13:16:36 OK_008 blog 这几天一直忙处理考勤自动匹配班次问题，比较郁闷拷了几天没有找到一个好的解决办法，只有制作个简单的例子，放分200放到CSDN上，终于在朋友的解答中找到一个解决方法. 原问题：--打卡记录表CREATE TABLE OriginalData([id] int IDENTITY(1,1),EmployeeID int,CheckTime datetime)INSERT INTO OriginalDataSELECT 1,'2007-06-11 08:01' UNION ALLSELECT 1,'2007-06-11 12:02' UNION ALLSELECT 1,'2007-06-11 13:05' UNION ALLSELECT 1,'2007-06-11 17:40' UNION ALLSELECT 1,'2007-06-11 19:00' UNION ALLSELECT 1,'2007-06-11 23:42' UNI... http://wghao.itpub.net/post/22404/294488 http://wghao.itpub.net/post/22404/294488 http://wghao.itpub.net/post/22404/294488 wghao SQL 2000 Wed,13 06 2007 16:23:06 OK_008 blog