<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Kingofcode的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/Kingofcode</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; Kingofcode]]></copyright><item><title><![CDATA[text根据公式自动计算。]]></title><link>https://blog.csdn.net/Kingofcode/article/details/4196903</link><guid>https://blog.csdn.net/Kingofcode/article/details/4196903</guid><author>Kingofcode</author><pubDate>Mon, 18 May 2009 10:53:00 +0800</pubDate><description><![CDATA[Dim s         If Text1 = "" Then Exit Sub     On Error GoTo errHandler     Set s = CreateObject("ScriptControl")     s.Language = "VBScript"     Text1 = s.Eval(Text1)     Set s = Nothing     flag = Tr]]></description><category></category></item><item><title><![CDATA[去掉数据库中的回车符和全角空格]]></title><link>https://blog.csdn.net/Kingofcode/article/details/3998374</link><guid>https://blog.csdn.net/Kingofcode/article/details/3998374</guid><author>Kingofcode</author><pubDate>Tue, 17 Mar 2009 15:28:00 +0800</pubDate><description><![CDATA[replace(replace(@str,char(13),),char(10),)  去掉全角空格replace(replace(string,   ,),　,) RTRIM()只能去掉半角空格]]></description><category></category></item><item><title><![CDATA[vb 获取文件的时间属性]]></title><link>https://blog.csdn.net/Kingofcode/article/details/3937574</link><guid>https://blog.csdn.net/Kingofcode/article/details/3937574</guid><author>Kingofcode</author><pubDate>Wed, 25 Feb 2009 22:35:00 +0800</pubDate><description><![CDATA[  Sub   ShowFileAccessInfo(filespec)             Dim   fs,   f,   s             Set   fs   =   CreateObject("Scripting.FileSystemObject")             Set   f   =   fs.GetFile(filespec)             s  ]]></description><category></category></item><item><title><![CDATA[简单的备份删除数据库]]></title><link>https://blog.csdn.net/Kingofcode/article/details/3879272</link><guid>https://blog.csdn.net/Kingofcode/article/details/3879272</guid><author>Kingofcode</author><pubDate>Wed, 11 Feb 2009 23:25:00 +0800</pubDate><description><![CDATA[backup  datasase 数据库名 to disk=路径/备份名.bak  删除数据库：IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N数据库名) DROP DATABASE [数据库名] GO ]]></description><category></category></item><item><title><![CDATA[标准行专列]]></title><link>https://blog.csdn.net/Kingofcode/article/details/3875515</link><guid>https://blog.csdn.net/Kingofcode/article/details/3875515</guid><author>Kingofcode</author><pubDate>Tue, 10 Feb 2009 22:42:00 +0800</pubDate><description><![CDATA[ 表：id--------name-------sort-------fen1--------zhang-------语文-------701--------zhang-------数学-------751--------zhang-------英语-------802--------wu-----------语文-------852--------wu----------]]></description><category></category></item><item><title><![CDATA[select 查询存储过程结果]]></title><link>https://blog.csdn.net/Kingofcode/article/details/3869768</link><guid>https://blog.csdn.net/Kingofcode/article/details/3869768</guid><author>Kingofcode</author><pubDate>Mon, 09 Feb 2009 10:06:00 +0800</pubDate><description><![CDATA[select * from openrowset( SQLOLEDB, sql服务器名; 用户名; 密码,exec 存儲過程) where 條件 例子：  SELECT * FROM OPENROWSET(SQLOLEDB, DRIVER={SQL Server};Server=.;UID=sa;PWD=,SET NOCOUNT ON  SET FMTONLY]]></description><category></category></item></channel></rss>