<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wangsm313的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wangsm313</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wangsm313]]></copyright><item><title><![CDATA[SQL Server個人數據庫安裝]]></title><link>https://blog.youkuaiyun.com/wangsm313/article/details/6558886</link><guid>https://blog.youkuaiyun.com/wangsm313/article/details/6558886</guid><author>wangsm313</author><pubDate>Tue, 21 Jun 2011 15:41:00 +0800</pubDate><description><![CDATA[最近因为工作需要，帮助同事安装单独的数据库，先将步骤记录下来。 個人數據庫安裝1.       下載MSDE200 RelAhttp://www.microsoft.com/downloads/en/details.aspx?familyid=413744d1-a0bc-479f-bafa-e4b278eb9147&displaylang=ens2.       解壓安裝。出現]]></description><category></category></item><item><title><![CDATA[存储过程(Procudure)]]></title><link>https://blog.youkuaiyun.com/wangsm313/article/details/6544073</link><guid>https://blog.youkuaiyun.com/wangsm313/article/details/6544073</guid><author>wangsm313</author><pubDate>Tue, 14 Jun 2011 16:07:00 +0800</pubDate><description><![CDATA[学习存储过程，并记录下来。1.简单的存储过程CREATE  PROCEDURE selGetdataASSELECT DISTINCT ISNULL(client_code,1) AS client_code FROM mapping_commission ORDER BY client_code ASC 执行EXEC selGetdata ]]></description><category></category></item><item><title><![CDATA[SQLSERVER 表数据生成INSERT语句]]></title><link>https://blog.youkuaiyun.com/wangsm313/article/details/6533237</link><guid>https://blog.youkuaiyun.com/wangsm313/article/details/6533237</guid><author>wangsm313</author><pubDate>Thu, 09 Jun 2011 10:00:00 +0800</pubDate><description><![CDATA[最近需要把一些数据生成insert语句，在网络上找到一个存储过程，尝试了下，感觉不错，记录下来。声明：此存储过程非原创，因为当初没有保存查找的站点，故无法标明具体来源，记录只是为方便以后学习使用。存储过程：set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER proc [dbo].[proc_insert] (]]></description><category></category></item></channel></rss>