<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wisdomone的专栏]]></title><description><![CDATA[数据库，这个系统工程，何时才能一窥真迹]]></description><link>https://blog.youkuaiyun.com/wisdomone</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wisdomone]]></copyright><item><title><![CDATA[/*-----------实现对科目分组下显示最大的成绩算法---------------*/]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1330517</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1330517</guid><author>wisdomone</author><pubDate>Wed, 11 Oct 2006 17:58:00 +0800</pubDate><description><![CDATA[/**//*-----------实现对科目分组下显示最大的成绩算法---------------*/create table liangfei2(学号 varchar(10),姓名 varchar(10),科目 varchar(10), 成绩 int)----建表insert liangfei2select 1,张三,语文,80 union allselect 2,李四]]></description><category></category></item><item><title><![CDATA[转贴马克的关于删除存在外键引用的主表之存储过程！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1329167</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1329167</guid><author>wisdomone</author><pubDate>Tue, 10 Oct 2006 19:40:00 +0800</pubDate><description><![CDATA[ 最近在做假资料时经常需要删除一些表中的内容。但是：设置外键后，想删除表中的数据无法删除，这时需删除外键后重建，或找到外键后用 alter table 表名 nocheck 外键名　来暂时屏蔽外键，然后删除。---alter table fktable nocheck干脆写个存储过程，设置外键的开关。exec fk_switch 表名,0 屏蔽外键 ----status 状态位（bit]]></description><category></category></item><item><title><![CDATA[转学用存储过程传入参数显示多行重复记录的实现过程！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1328795</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1328795</guid><author>wisdomone</author><pubDate>Tue, 10 Oct 2006 15:55:00 +0800</pubDate><description><![CDATA[create table bb(aid int,aname char(1),acom char(1))-------- 建测试表goinsert bb ---------------------插入记录select 1,a,d union allselect 2,b,c union allselect 3,k,s goselect *from bbgocreate pr]]></description><category></category></item><item><title><![CDATA[转群友一个关于显示了分组方式下问题！！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1328585</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1328585</guid><author>wisdomone</author><pubDate>Tue, 10 Oct 2006 13:24:00 +0800</pubDate><description><![CDATA[/**//*--------------------- 建立测试表-----------------------------------------------------------------------------------*/CREATE TABLE [tx] (                [name] [char] (2) COLLATE Chinese_PRC_CI_AS N]]></description><category></category></item><item><title><![CDATA[看优快云测试后，关于领导职工显示的问题！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1327814</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1327814</guid><author>wisdomone</author><pubDate>Mon, 09 Oct 2006 22:28:00 +0800</pubDate><description><![CDATA[create table staff(staff_id int,staff_name varchar(6))---建测试表,职工表goinsert staffselect 1,小王 union allselect 2,小刘 union allselect 3,赵科长union allselect 4,吴经理 union allselect 5, 董主任 goselect *]]></description><category></category></item><item><title><![CDATA[转优快云关于显示目录父子表算法！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1327793</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1327793</guid><author>wisdomone</author><pubDate>Mon, 09 Oct 2006 22:12:00 +0800</pubDate><description><![CDATA[ 一个部门的数据表,里面是目录树结构.如:  deptID  deptName  parentID里面的数据  是     1    所有部门   0                   2    财务部     1                   3    市场部     1                   4    仓库管理   1                   5   ]]></description><category></category></item><item><title><![CDATA[查指定表中每列的排序规则信息！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1326725</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1326725</guid><author>wisdomone</author><pubDate>Mon, 09 Oct 2006 07:23:00 +0800</pubDate><description><![CDATA[select  a.name,b.collationfrom syscolumns a   join syscolumns b   ------a, 得出表中的列名,b,得出 collation      on a.id =b.idwhere a.id=object_id(staff) and b.id=object_id(staff) and b.collation is not n]]></description><category></category></item><item><title><![CDATA[试一下优快云 BLOG的功能，哈哈！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1326687</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1326687</guid><author>wisdomone</author><pubDate>Mon, 09 Oct 2006 03:34:00 +0800</pubDate><description><![CDATA[    1,通过AD可以访问复制发布和订阅2,AD的发布及特性与SQLSERVER的发布属性存在差异？？3，你把要SQLSERVER实例添加到AD，要有帐户系统管理员。4，用T-SQL添加到AD,sp_activeDIrectory_SCP @ACTION=CREATE|DELETE ----把实例添加或删除到AD中5，将发布添加到AD中，在发布属性常规选项KAN中设置。6，使]]></description><category></category></item><item><title><![CDATA[转邹大哥显示同行中最小和最大的值！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1326666</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1326666</guid><author>wisdomone</author><pubDate>Mon, 09 Oct 2006 02:05:00 +0800</pubDate><description><![CDATA[create table t(col1 int,col2 int,col3 int)  ---- 创建一个测试表goinsert t ---插入记录select 1,2,3 union allselect 0,2,9 union allselect 8,4,7 union allselect 7,1,15 goselect * ---查询表记录from tgo--------------查询显]]></description><category></category></item><item><title><![CDATA[相关子查询！！！！！！！！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1326338</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1326338</guid><author>wisdomone</author><pubDate>Sun, 08 Oct 2006 19:28:00 +0800</pubDate><description><![CDATA[zxy(66915870) 10:40:39（表名为： t）有个表，属性为：编号 客户  订货产品                                   1    无锡  钢材                                   2    无锡  汽配件                                   3    无锡  电线          ]]></description><category></category></item><item><title><![CDATA[关于T-SQL 存储过程的学习！！！（加深理解）]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1324301</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1324301</guid><author>wisdomone</author><pubDate>Sat, 07 Oct 2006 15:47:00 +0800</pubDate><description><![CDATA[create proc p_getstr( @s varchar(8000),---- 测试串 @new varchar(8000) output--- 输出串)as declare           @pos int ---定义位置参数set @pos=patindex(%[a-z]%,@s) ------FU值，目的用来下面的WHILE判断set @new= -----FU值wh]]></description><category></category></item><item><title><![CDATA[复制又学习，温故！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1318542</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1318542</guid><author>wisdomone</author><pubDate>Tue, 03 Oct 2006 05:40:00 +0800</pubDate><description><![CDATA[ 对于还原用于分布式复制的数据库时，分几种情况1，如果此数据库复制类型为事务和合并，采用备份还原后，保持原有的复制配置2， 如果要从中恢复的故障要求完全重新创建将要还原到的数据库，则需要运行 sp_replicationdboption，或者在还原备份前启用数据库用于事务和合并发布。注意  如果未运行 sp_replicationdboption，复制设置将在还原操作中丢失。（sp_rel]]></description><category></category></item><item><title><![CDATA[利用binary_checksum(*)来查看基础表的更新！！！及 bulk insert 补充！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1316118</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1316118</guid><author>wisdomone</author><pubDate>Mon, 02 Oct 2006 07:36:00 +0800</pubDate><description><![CDATA[BULK INSERT pubs..authors2 FROM c:authors.txtWITH (   DATAFILETYPE = char,   FIELDTERMINATOR = ,,   CHECK_CONSTRAINTS)注：1，数据源可以是各种文件类型如：TXT，DAT，TBL等。2， firstrow -----lastrow定义复制数据的记录数据及其位置。3，D]]></description><category></category></item><item><title><![CDATA[对所有表进行类似处理]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1313725</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1313725</guid><author>wisdomone</author><pubDate>Sun, 01 Oct 2006 04:11:00 +0800</pubDate><description><![CDATA[ eg1:大家知道，如果将一个表所有者改为dbo，只需sp_changeobjectowner 表名,dbo即可但要将所有的表的所有者都改为dbo,可以用循环处理，此处略其实用SQL的系统存储过程sp_MSForEachTable可以轻松搞定只需exec sp_MSForEachTable sp_changeobjectowner ?, dbo当然，可能运行时会]]></description><category></category></item><item><title><![CDATA[分析邹健大哥的算法，终于问题解决了！！！（关于统计两日期间工作日）]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1313456</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1313456</guid><author>wisdomone</author><pubDate>Sun, 01 Oct 2006 01:12:00 +0800</pubDate><description><![CDATA[--计算两个日期之间相差的工作天数（本算法以2006-9-1至2006-9-30为例说明） CREATE FUNCTION f_WorkDateDiff( @dt_begin datetime, ----统计开始日期 @dt_end datetime)----统计结束日期 RETURNS int ----返回相差天数 AS BEGIN /**//*------@workday,工作日;@bz,]]></description><category></category></item><item><title><![CDATA[根据属性多少删除指定条件的重复记录！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1309542</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1309542</guid><author>wisdomone</author><pubDate>Sat, 30 Sep 2006 03:17:00 +0800</pubDate><description><![CDATA[where col1 in (select col1 from tb as t where t.col1=col1 group by col1 having count(col1)>1) --------根据单属性查重复值----上面运行结果如下：---col1   col21       a1       a1       a1       a2       c2       d--------]]></description><category></category></item><item><title><![CDATA[同名记录汇总！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1306406</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1306406</guid><author>wisdomone</author><pubDate>Fri, 29 Sep 2006 13:51:00 +0800</pubDate><description><![CDATA[ 如下表A   AA1A   AA2B   BB1B   BB2相应记录合并，并把字段二的合在一块，得出的结果为A   AA1,AA2B   BB1,BB2--测试数据create table csdn(id int,txt varchar(10))insert csdnselect 1,a union allselect 1,b union allselect 1,c union]]></description><category></category></item><item><title><![CDATA[动态语句学习·！！！~！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1306070</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1306070</guid><author>wisdomone</author><pubDate>Fri, 29 Sep 2006 12:38:00 +0800</pubDate><description><![CDATA[ -----用exec----- select * from tablename exec(select * from tablename) --------用sp_executesql---- exec sp_executesql Nselect * from tablename ---一定要加上N --------------------------------------------]]></description><category></category></item><item><title><![CDATA[看了群友的帖子，加深对相关子查询的理解！！！]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1305604</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1305604</guid><author>wisdomone</author><pubDate>Fri, 29 Sep 2006 10:47:00 +0800</pubDate><description><![CDATA[ create table test (CPBH char(7),LSH int default 0)insert test(CPBH) select 6666122insert test(CPBH) select 6666122insert test(CPBH) select 6666122insert test(CPBH) select 6666133insert test(C]]></description><category></category></item><item><title><![CDATA[currently look same sex some question!!!]]></title><link>https://blog.youkuaiyun.com/wisdomone/article/details/1305133</link><guid>https://blog.youkuaiyun.com/wisdomone/article/details/1305133</guid><author>wisdomone</author><pubDate>Fri, 29 Sep 2006 08:44:00 +0800</pubDate><description><![CDATA[create table wage(wage money,name1 char(4),sex char(2))insert wage values(100.1,zxy1,男)select *from wageinsert wage values(100.2,zxz,男)goinsert wage values(100.2,zxl,女)goinsert wage values]]></description><category></category></item></channel></rss>