sql-server

sql server 数据库管理书籍sql源码
................................\第01章
................................\......\1.9.1 设置内存选项.sql,209,2005-07-05
................................\......\1.9.2(2) 使用文件及文件组.sql,1629,2005-07-05
................................\......\1.9.2(3) 调整tempdb数据库的文件属性.sql,427,2005-07-05
................................\第02章
................................\......\2.1 日期概念理解中的一些测试.sql,1678,2005-07-06
................................\......\2.2.4 CONVERT在日期转换中的使用示例.sql,700,2005-07-06
................................\......\2.3.3 SET DATEFORMAT对日期处理的影响.sql,1692,2005-07-06
................................\......\2.3.4 SET LANGUAGE对日期处理的影响示例.sql,809,2005-07-06
................................\......\2.4.1 日期格式化处理.sql,587,2005-07-06
................................\......\2.4.2 日期推算处理.sql,1457,2005-07-06
................................\......\2.4.3 特殊日期加减函数.sql,2661,2005-07-06
................................\......\2.5.1 查询指定日期段内过生日的人员.sql,1370,2005-07-08
................................\......\2.5.2 生成日期列表的函数.sql,3396,2005-07-08
................................\......\2.5.3 工作日处理函数(标准节假日).sql,1793,2005-07-08
................................\......\2.5.3 工作日处理函数(自定义节假日).sql,1583,2005-07-08
................................\......\2.5.4 计算工作时间的函数.sql,2003,2005-07-08
................................\......\其他
................................\......\....\交叉表.sql,2230,2005-01-26
................................\......\....\任意两个时间之间的星期几的次数-横.sql,2955,2004-09-11
................................\......\....\任意两个时间之间的星期几的次数-纵.sql,1624,2004-08-21
................................\......\....\复杂年月处理.sql,1723,2003-09-20
................................\......\....\统计--交叉表%2B日期%2B优先.sql,2872,2005-01-19
................................\第03章
................................\......\3.2 各种字符串分拆处理函数.sql,4401,2005-07-09
................................\......\3.3 各种字符串合并处理示例.sql,3977,2005-07-09
................................\......\3.4.1 分段截取函数.sql,661,2005-07-10
................................\......\3.4.2 分段更新函数.sql,810,2005-07-10
................................\......\3.4.3 IP地址处理函数.sql,1144,2005-07-10
................................\......\3.5.1 字符串比较函数.sql,1937,2005-07-10
................................\......\3.5.2 字符串并集&交集处理示例.sql,1773,2005-07-10
................................\......\3.5.3 字符串分拆并统计的处理示例.sql,2444,2005-07-10
................................\......\3.5.5 字符串处理示例--列车车次查询.sql,1916,2005-07-10
................................\......\3.6.2 字符串在编号查询中的应用示例及常见问题.sql,2382,2005-07-10
................................\......\3.6.3 动态参数的存储过程示例.sql,1697,2005-07-10
................................\......\3.6.4 动态他Transact-SQL语句处理中的常见问题演示.sql,1345,2005-07-10
................................\......\3.7.3 text与ntext字段的复制和合并处理示例.sql,2011,2005-07-10
................................\......\3.7.4 text与image字段转换处理示例.sql,1179,2005-07-10
................................\......\3.7.5 ntext字段的REPLACE处理示例.sql,1792,2005-07-10
................................\......\其他
................................\......\....\varbinary转换成字符串.sql,659,2004-09-11
................................\......\....\关键字搜索.sql,2465,2004-11-12
................................\......\....\分解公式.sql,626,2003-08-14
................................\......\....\字符串分拆--格式化.sql,797,2005-04-01
................................\......\....\得到一个字符串在另一个字符串中出现的次数.sql,550,2004-02-29
................................\......\....\数字转换成十六进制.sql,512,2004-09-02
................................\......\....\比较第一与第二个字符串,是否有连续的5个字符相同.sql,2135,2003-12-16
................................\......\....\生成查询的模糊匹配字符串.sql,1776,2004-08-18
................................\......\....\简繁转换.sql,21595,2004-11-09
................................\......\....\统计一个表中某个字符出现最多的字母.sql,750,2003-07-15
................................\......\....\非法字符串处理.sql,1304,2005-04-19
................................\第04章
................................\......\4.1.5 在各种处理中应用排序规则的示例.sql,843,2005-07-10
................................\......\4.2.1 排序规则在拼音处理中的应用.sql,1671,2005-07-10
................................\......\4.2.2 排序规则在全角与半角处理中的应用.sql,1350,2005-07-10
................................\......\其他
................................\......\....\生成GB2312汉字表.sql,329,2005-04-04
................................\......\....\生成GBK汉字表.sql,1705,2004-06-04
................................\......\....\自动获取汉字笔画.sql,1678,2004-05-11
................................\第05章
................................\......\5.1.1 SET IDENTITY_INSERT 中的几个问题.sql,1304,2005-07-10
................................\......\5.1.1 修改标识值的示例.sql,415,2005-07-10
................................\......\5.1.1 标识列与普通列互相转换的示例.sql,709,2005-07-10
................................\......\5.2.1 查表法按日期生成流水号的示例.sql,896,2005-07-10
................................\......\5.2.1 查表法生成流水号的示例.sql,705,2005-07-10
................................\......\5.2.2 使用编号表按日期生成流水号的示例.sql,3076,2005-07-10
................................\......\5.2.2 使用编号表生成流水号的示例.sql,1148,2005-07-10
................................\......\5.2.3 生成纯字母随机编号的示例(仅大小或者小写).sql,800,2005-07-10
................................\......\5.2.3 生成纯字母随机编号的示例(大小写混合).sql,1013,2005-07-10
................................\......\5.2.3 生成纯数字随机编号的示例.sql,947,2005-07-10
................................\......\5.3.2 融合了补号处理的编号生成处理示例.sql,1446,2005-07-10
................................\......\5.3.3 使用UPDATE进行编号重排的处理示例.sql,648,2005-07-10
................................\......\5.3.3 使用临时表进行编号重排的处理示例.sql,760,2005-07-10
................................\......\5.3.3 使用子查询进行编号重排的处理示例.sql,657,2005-07-10
................................\......\5.3.3 名次查询的处理示例.sql,1194,2005-07-10
................................\......\5.4.1 查询已用编号分布情况的示例（临时表法).sql,850,2005-07-10
................................\......\5.4.1 查询已用编号分布情况的示例（子查询法).sql,780,2005-07-10
................................\......\5.4.2 查询缺号分布情况的示例.sql,1033,2005-07-10
................................\......\5.4.3 返回已用编号、缺号分布字符串的处理示例.sql,1674,2005-07-10
................................\......\5.4.4 缺勤天数统计的处理示例.sql,2408,2005-07-10
................................\......\其他
................................\......\....\-补位法.sql,1456,2004-04-25
................................\......\....\以另一个表的字段做默认值.sql,610,2003-12-15
................................\......\....\以另一表的字段生成编号.sql,2147,2004-05-26
................................\......\....\关联部门流水号.sql,1889,2004-03-19
................................\......\....\十六进制.sql,1363,2003-11-18
................................\......\....\学号.sql,1398,2003-11-19
................................\......\....\开票统计--涉及到连号处理.sql,3189,2003-07-17
................................\......\....\新编号查询示例(分类查询).sql,1467,2004-12-23
................................\......\....\新编号查询示例.sql,828,2004-12-23
................................\......\....\日期流水号.sql,1323,2004-11-14
................................\......\....\材料流水号.sql,1064,2003-12-15
................................\......\....\流水号.sql,1209,2004-02-27
................................\......\....\箱编号连号处理.sql,2208,2003-09-23
................................\......\....\类别自动生成编号示例.sql,1241,2004-07-10
................................\......\....\自已做标识列的例子.sql,1414,2004-12-22
................................\......\....\触发器自动维护已用&未用编号.sql,3986,2004-08-22
................................\......\....\连续编号.sql,949,2004-01-14
................................\......\....\防止重复的示例.sql,2028,2004-04-27