<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[silvanus的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/silvanus</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; silvanus]]></copyright><item><title><![CDATA[RSA 不可逆加解密简类]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/79638957</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/79638957</guid><author>silvanus</author><pubDate>Wed, 21 Mar 2018 13:47:23 +0800</pubDate><description><![CDATA[// 调用string tmpPriKey, tmpPubKey;            RsaHelper.GetPriPubKey(out tmpPriKey, out tmpPubKey);            string content = &quot;这是im 223~！ #苛sdkfj23&quot;;            string inString = RsaHelper.RsaEncrypt...]]></description><category></category></item><item><title><![CDATA[sqlserver 中查看一个库中有多少表是有数据的]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/79325290</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/79325290</guid><author>silvanus</author><pubDate>Wed, 14 Feb 2018 14:19:58 +0800</pubDate><description><![CDATA[declare @table table (rows int,tablename nvarchar(100));declare @sql NVARCHAR(MAX)declare @rows int;insert into @tableselect ROW_NUMBER() over (order by name),name from sysobjects where    xtype = 'u'...]]></description><category></category></item><item><title><![CDATA[CTE 递归]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/78654260</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/78654260</guid><author>silvanus</author><pubDate>Tue, 28 Nov 2017 13:51:32 +0800</pubDate><description><![CDATA[with cte(id) as(
select 1
union all 
select id + 1 from cte where id 
)
select * from cte]]></description><category></category></item><item><title><![CDATA[mysql 一行转多列]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/50683965</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/50683965</guid><author>silvanus</author><pubDate>Thu, 18 Feb 2016 09:40:28 +0800</pubDate><description><![CDATA[/*
drop table tbl_name;
create table tbl_name (ID int ,mSize varchar(100));
insert into tbl_name values (1,'tiny,small,big');
insert into tbl_name values (2,'small,medium');
insert into tbl_name ]]></description><category></category></item><item><title><![CDATA[ToDictionary test]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/45391407</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/45391407</guid><author>silvanus</author><pubDate>Thu, 30 Apr 2015 10:17:35 +0800</pubDate><description><![CDATA[public class Program
    {
        public static void Main()
        {
            List stulist = GetList();
            //// 如果有多个grand 是一样的，直接出错
            var dic1 = stulist.ToDictionary(m =]]></description><category></category></item><item><title><![CDATA[【转】SQL SERVER 查看SQL语句IO,时间，索引消耗]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/43866417</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/43866417</guid><author>silvanus</author><pubDate>Tue, 17 Feb 2015 15:03:53 +0800</pubDate><description><![CDATA[1.查看SQL语句IO消耗

set statistics io on 
    select * from dbo.jx_order where order_time>'2011-04-12 12:49:57.580' 
set statistics io off

 




 

 2.查看SQL语句时间消耗

set statistics time on 
]]></description><category></category></item><item><title><![CDATA[2000 动态 行列转换]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8494068</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8494068</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:53:42 +0800</pubDate><description><![CDATA[if object_id('tb')is not null drop table tb

go

create table tb(姓名 varchar(10),课程 varchar(10),分数 int)

insert into tb values('张三','语文',74)

insert into tb values('张三','数学',83)

insert into tb values(]]></description><category></category></item><item><title><![CDATA[兔子]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8494038</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8494038</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:48:33 +0800</pubDate><description><![CDATA[if Exists(select * from sysobjects where id = object_id('calrabbit'))
begin
drop function dbo.calrabbit 
end
go
create function dbo.calrabbit(@i int,@month int)
returns  int
as
begin
if (@i]]></description><category></category></item><item><title><![CDATA[猴子]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8494033</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8494033</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:48:05 +0800</pubDate><description><![CDATA[猴子第一天摘下若干个桃子，当即吃了一半，还不过瘾，又多吃了一个，第二天早上又将剩下的桃子吃掉一半，又多吃了一个，以后每天早上都吃了前一天剩下的一半零一个，到第十天早上，再想吃时，见只剩下一个桃子了，求第一天一个摘了多少个桃子
if Exists(select * from sysobjects where id = object_id('calpeaches'))
begin
drop fu]]></description><category></category></item><item><title><![CDATA[一个连续数字]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8494023</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8494023</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:46:45 +0800</pubDate><description><![CDATA[--100次递归
with cte1 as
(
select 1 i
),cte3 as
(
select i from cte1 
union all 
select i+1 i from cte3 where 
i 
)
select * from cte3


--spt_value,只到2047
select number+1 from master..spt]]></description><category></category></item><item><title><![CDATA[百万插入]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8493997</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8493997</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:42:26 +0800</pubDate><description><![CDATA[/*****************************一个方法******************************/
 ---判断Nums 表是否存在，存在即将其删除  
 IF OBJECT_ID('dbo.Nums') IS NOT NULL 
      DROP TABLE dbo.Nums;  
 GO  
 ---重新创建表  
 CREATE TABLE d]]></description><category></category></item><item><title><![CDATA[一列转一行]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8493978</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8493978</guid><author>silvanus</author><pubDate>Fri, 11 Jan 2013 15:39:56 +0800</pubDate><description><![CDATA[/*
表tb
col 
11
aa
cc

想要的结果
s1,s2,s3 --显示字段名
11,aa,cc --数据结果
*/
/***************临时表解决方案****************************************************************************************/
-- 创建数据
if Exists(selec]]></description><category></category></item><item><title><![CDATA[sp_who_lock]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8444159</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8444159</guid><author>silvanus</author><pubDate>Thu, 27 Dec 2012 16:09:45 +0800</pubDate><description><![CDATA[use master
go
create procedure sp_who_lock
as
begin
declare @spid int,@bl int,
 @intTransactionCountOnEntry  int,
        @intRowcount    int,
        @intCountProperties   int,
        @intCounter]]></description><category></category></item><item><title><![CDATA[找出SQL中的死锁进程]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8439088</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8439088</guid><author>silvanus</author><pubDate>Wed, 26 Dec 2012 14:51:16 +0800</pubDate><description><![CDATA[select a.resource_type, 
case a.resource_type
when 'RID' then '行锁（表没有聚集索引表）'
when 'KEY' then '行锁（表有聚集索引表）'
when 'Page' then '数据页锁'
when 'EXTEnt' then '连续8个页面集合锁'
when 'Hobt' then '堆或平衡树锁（表没有聚集索引]]></description><category></category></item><item><title><![CDATA[SQLServer找出执行慢的SQL语句]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/8424227</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/8424227</guid><author>silvanus</author><pubDate>Mon, 24 Dec 2012 11:42:44 +0800</pubDate><description><![CDATA[SELECT
(total_elapsed_time / execution_count)/1000 N'平均时间ms'
,total_elapsed_time/1000 N'总花费时间ms'
,total_worker_time/1000 N'所用的CPU总时间ms'
,total_physical_reads N'物理读取总次数'
,total_logical_reads/execution_]]></description><category></category></item><item><title><![CDATA[执行动态SQL，并返回一个值]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/7835852</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/7835852</guid><author>silvanus</author><pubDate>Mon, 06 Aug 2012 16:17:38 +0800</pubDate><description><![CDATA[declare @recordCount int
declare @sql nvarchar(max)
set @sql = 'select @count = count(*) from table'
exec sp_executesql @sql,N'@count int out',@recordCount out
select @recordCount]]></description><category></category></item><item><title><![CDATA[SQL 中的正则 查询]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/7823830</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/7823830</guid><author>silvanus</author><pubDate>Thu, 02 Aug 2012 17:08:42 +0800</pubDate><description><![CDATA[语法格式：PATINDEX ( '%pattern%' , expression )



 


返回pattern字符串在表达式expression里第一次出现的位置，起始值从1开始算。

pattern字符串在expression表达式里没找就返回0，对所有有效的文本和字符串就是有效的数据类型。

描述一下此函数的具体用法：


1. PATINDEX ( '%p]]></description><category></category></item><item><title><![CDATA[模糊查询 按字数多少排序]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/7747887</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/7747887</guid><author>silvanus</author><pubDate>Sun, 15 Jul 2012 00:08:50 +0800</pubDate><description><![CDATA[declare @key nvarchar(20)
set @key = '打印机 ibm a'

declare @return nvarchar(100)
declare @sql nvarchar(max)
set @sql  = ''
if charindex(' ',@key) > 0
begin
	while charindex(' ',@key) > 0 
    begin]]></description><category></category></item><item><title><![CDATA[SQL Server DbLink]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/7715177</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/7715177</guid><author>silvanus</author><pubDate>Wed, 04 Jul 2012 14:47:39 +0800</pubDate><description><![CDATA[Exec sp_droplinkedsrvlogin LinkServer,Null --若存在先刪除
Exec sp_dropserver LinkServer
EXEC sp_addlinkedserver
@server= 'LinkServer',--被訪問的服務器別名
@srvproduct= '',
@provider= 'SQLOLEDB',
@datasrc= '192.168.0]]></description><category></category></item><item><title><![CDATA[MSSQL 行列转换]]></title><link>https://blog.youkuaiyun.com/silvanus/article/details/7683835</link><guid>https://blog.youkuaiyun.com/silvanus/article/details/7683835</guid><author>silvanus</author><pubDate>Thu, 21 Jun 2012 18:21:44 +0800</pubDate><description><![CDATA[--普通版行列转换
create table tb(姓名 varchar(10) , 课程 varchar(10) , 分数 int) 
insert into tb values('张三' , '语文' , 74) 
insert into tb values('张三' , '数学' , 83) 
insert into tb values('张三' , '物理' , 93) 
insert i]]></description><category></category></item></channel></rss>