<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qin_yaping的博客]]></title><description><![CDATA[一名菜鸡程序猿，正在努力学习中~~~~]]></description><link>https://blog.youkuaiyun.com/qin_yaping</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qin_yaping]]></copyright><item><title><![CDATA[查询死锁sql]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/148403549</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/148403549</guid><author>qin_yaping</author><pubDate>Tue, 03 Jun 2025 15:59:42 +0800</pubDate><description><![CDATA[SELECTer.reads,er.writes,er.status,wait_type,host_name,nt_domainFROMWHEREORDER BY1, 2。]]></description><category></category></item><item><title><![CDATA[查询表所有字段]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/142967815</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/142967815</guid><author>qin_yaping</author><pubDate>Wed, 16 Oct 2024 02:03:45 +0800</pubDate><description><![CDATA[declare @COLSQL varchar(2000)
SELECT @COLSQL = ISNULL(@COLSQL + ',', '') + NAME FROM SYSCOLUMNS WHERE ID=OBJECT_ID(@TableName) order by colid;
select @COLSQL]]></description><category></category></item><item><title><![CDATA[批量杀死数据库死锁]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/141256462</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/141256462</guid><author>qin_yaping</author><pubDate>Fri, 16 Aug 2024 12:21:47 +0800</pubDate><description><![CDATA[fromwhereBEGINEND。]]></description><category></category></item><item><title><![CDATA[sql怎么取某个字符串最后一次出现的位置后面的字符串]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/129281696</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/129281696</guid><author>qin_yaping</author><pubDate>Wed, 01 Mar 2023 15:01:48 +0800</pubDate><description><![CDATA[.]]></description><category></category></item><item><title><![CDATA[Sql Server查数据库job任务]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/127632805</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/127632805</guid><author>qin_yaping</author><pubDate>Wed, 02 Nov 2022 14:10:59 +0800</pubDate><description><![CDATA[BEGIN。]]></description><category></category></item><item><title><![CDATA[SQL SERVER 查询Job作业基本信息及执行情况]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/127632859</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/127632859</guid><author>qin_yaping</author><pubDate>Tue, 01 Nov 2022 14:16:35 +0800</pubDate><description><![CDATA[3 , 0 , ':' ), 6 , 0 , ':' ) AS '最后运行持续时间'LEFT JOIN [msdb].[dbo].[sysproxies] AS [px]--代理账户信息。,[jstep].[step_uid] AS '作业步骤唯一标识符',[jstep].[step_uid] AS '步骤唯一标识符',[jstep].[step_name] AS '步骤名称',[jstep].[step_name] AS '步骤名称',[step].[step_name] AS '步骤名称']]></description><category></category></item><item><title><![CDATA[SQLServer——MASTER..spt_values]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/126778590</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/126778590</guid><author>qin_yaping</author><pubDate>Fri, 09 Sep 2022 10:47:32 +0800</pubDate><description><![CDATA[SQLServer——MASTER..spt_values]]></description><category></category></item><item><title><![CDATA[GridControll自定义绘制表格颜色]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/125430270</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/125430270</guid><author>qin_yaping</author><pubDate>Thu, 23 Jun 2022 16:48:53 +0800</pubDate><description><![CDATA[GridControll自定义绘制表格颜色]]></description><category></category></item><item><title><![CDATA[sql server查询表的主键名跟主键字段]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/122927416</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/122927416</guid><author>qin_yaping</author><pubDate>Mon, 14 Feb 2022 16:37:15 +0800</pubDate><description><![CDATA[SELECT CONSTRAINT_NAME,
   COLUMN_NAME = ( STUFF(( SELECT  ',' + COLUMN_NAME
        FROM   INFORMATION_SCHEMA.KEY_COLUMN_USAGE
        WHERE   TABLE_NAME = Test.TABLE_NAME
     ...]]></description><category></category></item><item><title><![CDATA[c# json字符串转成datatable]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/115496261</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/115496261</guid><author>qin_yaping</author><pubDate>Wed, 07 Apr 2021 21:16:25 +0800</pubDate><description><![CDATA[JsonConvert.DeserializeObject(paramList[5].ToString())
其中paramList[5].ToString()是一个json字符串。可以直接通过这个方法转成DataTable

]]></description><category></category></item><item><title><![CDATA[SQL删除重复数据只保留一条]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/109410274</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/109410274</guid><author>qin_yaping</author><pubDate>Sun, 01 Nov 2020 00:57:39 +0800</pubDate><description><![CDATA[SQL删除重复数据只保留一条
用SQL语句,删除掉重复项只保留一条
在几千条记录里,存在着些相同的记录,如何能用SQL语句,删除掉重复的呢
1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) &gt; 1)
2、删除表中多余的重复记录，重复记录是根据单个字段（peop]]></description><category></category></item><item><title><![CDATA[Delphi 如何GET/POST 调用HTTP请求]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/108448717</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/108448717</guid><author>qin_yaping</author><pubDate>Mon, 07 Sep 2020 15:17:47 +0800</pubDate><description><![CDATA[一、GET 请求

procedure GetDemo;
var
 IdHttp : TIdHTTP;
 Url : string;//请求地址
 ResponseStream : TStringStream; //返回信息
 ResponseStr : string;
begin
 //创建IDHTTP控件
 IdHttp := TIdHTTP.Create(nil);
 //TStringStream对象用于保存响应信息
 ResponseStream := TStringStream....]]></description><category></category></item><item><title><![CDATA[C# Process.Start()方法详解]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/107581464</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/107581464</guid><author>qin_yaping</author><pubDate>Sat, 25 Jul 2020 17:09:30 +0800</pubDate><description><![CDATA[https://blog.youkuaiyun.com/chen_zw/article/details/7896264
]]></description><category></category></item><item><title><![CDATA[SQL SERVER列信息转换成字符串信息显示]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/105448172</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/105448172</guid><author>qin_yaping</author><pubDate>Sat, 11 Apr 2020 10:32:34 +0800</pubDate><description><![CDATA[通过函数STUFF转换

例子写法如下：

SELECT STUFF((SELECT ';'+SPDM FROM SHANGPIN where SPDM in ('545454','BZSP01','HSP02','HSP05') for xml path('')),1,1,'')
]]></description><category></category></item><item><title><![CDATA[SQL SERVER 存储过程调用时更新自身数据时（脚本例子）]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/105066539</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/105066539</guid><author>qin_yaping</author><pubDate>Tue, 24 Mar 2020 10:54:33 +0800</pubDate><description><![CDATA[if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[P_ICACZNPH_CKDDPH_PH]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[P_ICACZNPH_CKDDPH_PH]
GO

CREATE procedu...]]></description><category></category></item><item><title><![CDATA[删除表数据触发器记录删除的数据]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/104309181</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/104309181</guid><author>qin_yaping</author><pubDate>Fri, 14 Feb 2020 11:42:24 +0800</pubDate><description><![CDATA[create trigger trigger_SDPHD
on SDPHD
after delete
as
declare @DJBH varchar(20)

--从删除表里面获取出来这个删除的数据
select @DJBH=DJBH from deleted
begin
 --delete SDPHD_DELETE where DJBH=@DJBH
 insert into SDP...]]></description><category></category></item><item><title><![CDATA[sql 的阻塞查询（2008版本的）]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/90813961</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/90813961</guid><author>qin_yaping</author><pubDate>Tue, 04 Jun 2019 21:47:46 +0800</pubDate><description><![CDATA[1

			2

			3

			4

			5

			6

			7

			8

			9

			10

			11

			12

			13

			14

			15

			16

			17

			18

			19

			20

			21

			22

			23

			24

			25

			26

			27

			28

			29

			30...]]></description><category></category></item><item><title><![CDATA[Delphi中copy函数和pos函数]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/89919948</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/89919948</guid><author>qin_yaping</author><pubDate>Tue, 07 May 2019 14:12:06 +0800</pubDate><description><![CDATA[copy（a,b,c);

a：就是copy源，就是一个字符串，表示你将要从a里copy一些东西，

b：从a中的第b位开始copy（包含第b位），

c：copy从第b位开始后的c个字符，

exp：

m:=‘the fellowship of the ring’

s：=copy（m,2,2）； ...]]></description><category></category></item><item><title><![CDATA[sql server对数据进行先进先出]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/89509668</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/89509668</guid><author>qin_yaping</author><pubDate>Thu, 25 Apr 2019 09:54:27 +0800</pubDate><description><![CDATA[--&gt; 测试数据：[m]
if object_id('[m]') is not null drop table [m]
go
Create table m ( ID int not NULL , mCount int not NULL ,mTime datetime not null)
INSERT into m(ID,mCount,mTime)
SELECT 1,50,'2014-0...]]></description><category></category></item><item><title><![CDATA[sql 按组分查出一条数据出来]]></title><link>https://blog.youkuaiyun.com/qin_yaping/article/details/86626342</link><guid>https://blog.youkuaiyun.com/qin_yaping/article/details/86626342</guid><author>qin_yaping</author><pubDate>Thu, 24 Jan 2019 14:31:45 +0800</pubDate><description><![CDATA[ SELECT * FROM ( SELECT ROW_NUMBER() OVER(PARTITION BY DJBH ORDER BY JE_S ) AS CNT,DJBH,KL
 FROM HTSZDMX2 ) A WHERE CNT=1

 

这个语句是按单据编号DJBH分组。相同单据编号分成一个组，给他们CNT号。然后就可以查出一条数据出来了...]]></description><category></category></item></channel></rss>