<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lang071234</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lang071234]]></copyright><item><title><![CDATA[mysql 乱码问题。]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/5123309</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/5123309</guid><author>lang071234</author><pubDate>Sun, 03 Jan 2010 06:56:00 +0800</pubDate><description><![CDATA[show variables like character%;查看字符编码 --更改字符集 SET character_set_client = utf-8 ; SET character_set_connection = utf-8 ; SET character_set_database = utf-8 ; SET character_set_results = utf-8 ; SET c]]></description><category></category></item><item><title><![CDATA[删除重复记录有大小关系时,保留大或小其中一个记录]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/5006889</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/5006889</guid><author>lang071234</author><pubDate>Mon, 14 Dec 2009 22:41:00 +0800</pubDate><description><![CDATA[删除重复记录有大小关系时,保留大或小其中一个记录--> --> (Roy)生成測試數據if not object_id(Tempdb..#T) is null    drop table #TGoCreate table #T([ID] int,[Name] nvarchar(1),[Memo] nvarchar(2))Insert #Tselect 1,NA,NA1 union al]]></description><category></category></item><item><title><![CDATA[求时间差]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/4915620</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/4915620</guid><author>lang071234</author><pubDate>Tue, 01 Dec 2009 16:41:00 +0800</pubDate><description><![CDATA[declare @date1 datetime,@date2 datetimeset @date1=2009-12-01 14:38:00set @date2=2009-12-04 14:38:00select 时间差 = cast(datediff(second , @date1, @date2) / (24*60*60) as varchar) + 天 + cast((datedi]]></description><category></category></item><item><title><![CDATA[日期格式转换]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/4913818</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/4913818</guid><author>lang071234</author><pubDate>Tue, 01 Dec 2009 13:09:00 +0800</pubDate><description><![CDATA[SELECT CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSELECT CONVERT(varchar(100), GETDATE(), 1): 05/16/06SELECT CONVERT(varchar(100), GETDATE(), 2): 06.05.16SELECT CONVERT(varchar(100), GETDA]]></description><category></category></item><item><title><![CDATA[定期删除]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/4833433</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/4833433</guid><author>lang071234</author><pubDate>Thu, 19 Nov 2009 10:34:00 +0800</pubDate><description><![CDATA[ create proc p_wspas    declare @star datetime    set datefirst 1    set @star=convert(varchar(7),getdate(),120)+-01    if(datepart(dw,@star)=7)        set @star=dateadd(dd,1,@star)    --得到这个月第一个星]]></description><category></category></item><item><title><![CDATA[sql server05 用MD5加密（转）]]></title><link>https://blog.youkuaiyun.com/lang071234/article/details/4813109</link><guid>https://blog.youkuaiyun.com/lang071234/article/details/4813109</guid><author>lang071234</author><pubDate>Sun, 15 Nov 2009 16:44:00 +0800</pubDate><description><![CDATA[ -- =============================================-- Description:  实现MD5加密算法，返回对字符串的加密结果串-- =============================================ALTER FUNCTION [dbo].[MD5] (    -- 源字符串    @src varchar(255), ]]></description><category></category></item></channel></rss>