<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[diechanlao5317的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/diechanlao5317</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; diechanlao5317]]></copyright><item><title><![CDATA[sql server查询数据库连接数]]></title><link>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359209</link><guid>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359209</guid><author>diechanlao5317</author><pubDate>Tue, 17 Sep 2019 17:27:00 +0800</pubDate><description><![CDATA[设置最大连接数下面的T-SQL 语句可以配置SQL Server 允许的并发用户连接的最大数目。exec sp_configure 'show advanced options', 1exec sp_configure 'user connections', 100第一句用以表示显示sp_configure系统存储过程高级选项，使用user connections 时，要求show...]]></description><category></category></item><item><title><![CDATA[sql server 查询某段日期某段时间内的数据]]></title><link>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359207</link><guid>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359207</guid><author>diechanlao5317</author><pubDate>Sun, 15 Sep 2019 23:00:00 +0800</pubDate><description><![CDATA[如我要取8月1号到8月30号之间的早上7点半到晚上八点半这段时间内的数据。

SELECT *
FROM tableName AS tWHERE  t.create_date BETWEEN '2017-08-01 07:30' AND '2017-08-30 20:30'       AND CONVERT(CHAR(5), t.create_date, 14) BETWEEN...]]></description><category></category></item><item><title><![CDATA[SQL 查看某个表被哪些存储过程或者视图使用]]></title><link>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359208</link><guid>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359208</guid><author>diechanlao5317</author><pubDate>Wed, 08 May 2019 08:49:00 +0800</pubDate><description><![CDATA[--查询某个表被哪些视图/存储过程使用（type='P':表示存储过程，type='V':表示视图）
SELECT OBJECT_NAME(id) FROM syscomments WHERE id IN(SELECT object_id FROM sys.objects WHERE type='P')AND text LIKE '%表名称%'
--查看字段在哪些表中使用
sele...]]></description><category></category></item><item><title><![CDATA[Python 列表（List）]]></title><link>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359206</link><guid>https://blog.youkuaiyun.com/diechanlao5317/article/details/102359206</guid><author>diechanlao5317</author><pubDate>Sun, 21 Apr 2019 11:02:00 +0800</pubDate><description><![CDATA[列表是最常用的Python数据类型，它可以作为一个方括号内的逗号分隔值出现。
列表的数据项不需要具有相同的类型。
一.列表定义
用逗号分隔不同的数据项使用方括号括起来。

&gt;&gt;&gt; list1 = ['Python','Java','C#','1925',"admin",256]
&gt;&gt;&gt; list2 = [1,5,3,8,12]
&gt;&...]]></description><category></category></item></channel></rss>