<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_29954875的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_29954875</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_29954875]]></copyright><item><title><![CDATA[秒表计时器]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/139919537</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/139919537</guid><author>qq_29954875</author><pubDate>Mon, 24 Jun 2024 10:55:32 +0800</pubDate><description><![CDATA[sb.AppendLine($"  {i:00} 用时= {_steps[i].end.Subtract(_steps[i].start).TotalMilliseconds,6:0.0} 毫秒\t{_steps[i].stepname}\t开始时间={_steps[i].start:HH:mm:ss.fff}");public StopWatch() : this("未命名") { }/// 到现在为止的用时。/// 跳过这段时间。]]></description><category></category></item><item><title><![CDATA[sqlserver/mysql 行转列 合并栏位]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/119384713</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/119384713</guid><author>qq_29954875</author><pubDate>Thu, 05 Aug 2021 15:27:15 +0800</pubDate><description><![CDATA[1. 学生表



2.成绩表



实现的结果：



sqlserver 语句：

select DISTINCT s.id,s.name,s.age,
stuff((select ',' + r.cource +':'+ r.score from score r
where s.id = r.sid for XML PATH('')), 1, 1, '')as last_result
from student s

-- group by s.id,s.name,s.age

mysql...]]></description><category></category></item><item><title><![CDATA[多线程问题处理--Semaphore 使用，有实例]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/116782584</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/116782584</guid><author>qq_29954875</author><pubDate>Fri, 14 May 2021 10:48:55 +0800</pubDate><description><![CDATA[1.理解Semaphore及其用法

2.需求描述，弹窗展示数据的变化情况：实现效果如下



3.部分代码如下：


]]></description><category></category></item><item><title><![CDATA[Oracle 删除重复数据只留一条]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/89472031</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/89472031</guid><author>qq_29954875</author><pubDate>Tue, 23 Apr 2019 14:33:11 +0800</pubDate><description><![CDATA[转载地址：https://www.cnblogs.com/252e/archive/2012/09/13/2682817.html
]]></description><category></category></item><item><title><![CDATA[关于数据库约束]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/89414394</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/89414394</guid><author>qq_29954875</author><pubDate>Sat, 20 Apr 2019 11:04:47 +0800</pubDate><description><![CDATA[转载地址：https://www.cnblogs.com/seven7seven/p/3730825.html

详细操作参考上述地址

简单实用

1.查询约束：

SELECT* FROMuser_constraints WHERE table_name = '表名'



2.删除约束

ALTER TABLE 表名DROP CONSTRAINT SYS_C00325...]]></description><category></category></item><item><title><![CDATA[oracle 误删数据恢复]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/88694906</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/88694906</guid><author>qq_29954875</author><pubDate>Wed, 20 Mar 2019 17:44:46 +0800</pubDate><description><![CDATA[转载：https://www.cnblogs.com/hqbhonker/p/3977200.html



已试过delete方法删除的数据恢复

1.查找删除的数据

select * from 表名as of timestamp to_timestamp('2019-03-20 17:20:00','yyyy-mm-dd hh24:mi:ss')

其中 时间可以填写到你删除时间前都可以...]]></description><category></category></item><item><title><![CDATA[常数 根据值获取名称]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/88576039</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/88576039</guid><author>qq_29954875</author><pubDate>Fri, 15 Mar 2019 15:40:40 +0800</pubDate><description><![CDATA[public class shengshijibie
  {
    public const string 省属 = &quot;01&quot;;
    public const string 市属 = &quot;02&quot;;
    public const string 其它 = &quot;03&quot;;
    public const string 所有 = &quot;99&quot;;

  }...]]></description><category></category></item><item><title><![CDATA[c# npoi 导出excel 简单应用]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/88033309</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/88033309</guid><author>qq_29954875</author><pubDate>Thu, 28 Feb 2019 16:27:44 +0800</pubDate><description><![CDATA[参考文章地址：https://blog.youkuaiyun.com/smartsmile2012/article/details/81559320

1.DataTable 导出excel   

public static int TableToExcel(DataTable dt, string fileName, Dictionary&amp;lt;string, string&amp;gt; cellhe...]]></description><category></category></item><item><title><![CDATA[Oracle 批量insert 语句]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/86160788</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/86160788</guid><author>qq_29954875</author><pubDate>Wed, 09 Jan 2019 16:51:32 +0800</pubDate><description><![CDATA[ 

INSERT ALL

INTO TableName VALUE('','','',....)

INTO TableName VALUE('','','',....)

INTO TableName VALUE('','','',....)

.......

SELECT   1  FROM   DUAL

 

或者

INSERT ALL

INTO TableName（xxx,xx...]]></description><category></category></item><item><title><![CDATA[sqlserver 批量插入问题]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/82496947</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/82496947</guid><author>qq_29954875</author><pubDate>Fri, 07 Sep 2018 15:19:26 +0800</pubDate><description><![CDATA[方法一：



方法二：



方法三：



当插入条目超过1000条时：

方法三 会报错，提示超出限制，此时建议使用第二种方法，实际项目中遇到上述问题 供大家参考

参考地址：https://www.2cto.com/database/201704/622187.html

 

 

 

 ...]]></description><category></category></item><item><title><![CDATA[快速排序方法]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/81806300</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/81806300</guid><author>qq_29954875</author><pubDate>Sat, 18 Aug 2018 10:33:54 +0800</pubDate><description><![CDATA[链接地址：https://mp.weixin.qq.com/s/I_LZADZyQ-66hrup83_ewQ

讲解详细，值得学习！！]]></description><category></category></item><item><title><![CDATA[根据一个表的字段 更新另一个字段的值]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/81329450</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/81329450</guid><author>qq_29954875</author><pubDate>Wed, 01 Aug 2018 13:55:24 +0800</pubDate><description><![CDATA[转载： 原文：http://blog.youkuaiyun.com/jcx5083761/article/details/26010763

 

1. 写法轻松，更新效率高(SqlServer写法)：
update table1 
set field1=table2.field1,
field2=table2.field2
from table2
where table1.id=table2.id

 

...]]></description><category></category></item><item><title><![CDATA[关于考勤的几个查询]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/80983036</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/80983036</guid><author>qq_29954875</author><pubDate>Tue, 10 Jul 2018 17:11:07 +0800</pubDate><description><![CDATA[1. 显示某一天的 上班，下班数据样式：sql：SELECT u.name,s.iname,s.CheckTime,x.iname,x.CheckTime from Users uLEFT JOIN (SELECT UserId, CheckTime, MIN(CheckTime) mindatetime, iname FROM WX_Sign where iname = '上班' GROUP B...]]></description><category></category></item><item><title><![CDATA[sql -递归查询组织机构某节点下所有及最底层]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/80982328</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/80982328</guid><author>qq_29954875</author><pubDate>Tue, 10 Jul 2018 11:11:17 +0800</pubDate><description><![CDATA[1. 表1.查询某一节点下的所有节点WITH OrganizeTree AS ( SELECT name, pid, wid FROM Organize WHERE pid = '2362'UNION ALL SELECT Organize.name, Organize.pid, Organize.wid FROM OrganizeTree JOIN Organize ON OrganizeTre...]]></description><category></category></item><item><title><![CDATA[sql 分组统计，数据为空时显示0]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/80203119</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/80203119</guid><author>qq_29954875</author><pubDate>Mon, 07 May 2018 16:58:34 +0800</pubDate><description><![CDATA[1.未添加时间搜索条件，查询结果如下2. 添加时间添加后，未有符合条件的数据，呈现的结果如下：实际想要的结果 应该是如下情况：直接上代码：SELECT	name,	SUM (Total) AS total,	SUM (Untreated) AS untreated,	SUM (Dealing) AS dealing,	SUM (Handled) AS handledFROM	(		SELECT o...]]></description><category></category></item><item><title><![CDATA[单表删除某条数据的所有子数据]]></title><link>https://blog.youkuaiyun.com/qq_29954875/article/details/79957310</link><guid>https://blog.youkuaiyun.com/qq_29954875/article/details/79957310</guid><author>qq_29954875</author><pubDate>Mon, 16 Apr 2018 10:36:09 +0800</pubDate><description><![CDATA[表结构如下：删除 id=1的数据，注意 此时要删除其所有子数据：其中还应包括pid='1','11','111'的数据查询出与 id=1 相关的所有的数据id：//==================WITH Emp AS (	SELECT		ID,		Pid	FROM		City 	WHERE		ID = '1'	UNION ALL		SELECT			d.ID,			d.Pid		FROM		...]]></description><category></category></item></channel></rss>