<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[River]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/binhe521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; binhe521]]></copyright><item><title><![CDATA[用datasource来绑定gridview如何进行修改，更新，删除]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/6025030</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/6025030</guid><author>binhe521</author><pubDate>Sun, 21 Nov 2010 15:30:00 +0800</pubDate><description><![CDATA[<br />以前使用gridview都是使用datasource来绑定数据。这样开发速度在初期是很快。但是，用久了，会发现它的极限。于是改用手写编辑。但是，竟然一下子不会写了。每次都说：GridView“GridView1”激发了未处理的事件“RowEditing”。 <br />真的很郁闷。在cs中也写上了GridView1_RowEditing处理事件了。在网上看了，好像也没有什么用。后来我才在一片文章中发现，原来在aspx文件上的gridview控件上要加上几个事件来触发GridView1_RowEd]]></description><category></category></item><item><title><![CDATA[sqlcommand 使用方法]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/5487709</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/5487709</guid><author>binhe521</author><pubDate>Thu, 15 Apr 2010 10:18:00 +0800</pubDate><description><![CDATA[使用sqlcommand对象来返回数据集合的方法string strconn="data source=billgates;initial catalog=test;integrated security=SSPI;";SqlConnection conn=new SqlConnection(strconn);conn.Open();SqlCommand sqlcmd=new SqlComma]]></description><category></category></item><item><title><![CDATA[oracle启动命令]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/5253282</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/5253282</guid><author>binhe521</author><pubDate>Mon, 25 Jan 2010 11:46:00 +0800</pubDate><description><![CDATA[1、startup nomount 非安装启动，这种方式启动下可执行：重建控制文件、重建数据库读取init.ora文件，启动instance，即启动SGA和后台进程，这种启动只需要init.ora文件。2、startup mount dbname安装启动，这种方式启动下可执行：数据库日志归档、数据库介质恢复、使数据文件联机或脱机，重新定位数据文件、重做日志文件。执行]]></description><category></category></item><item><title><![CDATA[oracle--v$lock type字段详解 ]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/4509951</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/4509951</guid><author>binhe521</author><pubDate>Wed, 02 Sep 2009 09:48:00 +0800</pubDate><description><![CDATA[NameDescriptionADASM Disk AU LockAFAdvisor FrameworkAGAnalytic Workspace GenerationAKGES Deadlock TestAOMultiWriter Object AccessASService Opera]]></description><category></category></item><item><title><![CDATA[V$LOGFILE.STATUS 和V$LOG.STATUS字段值的含义 ]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/4492209</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/4492209</guid><author>binhe521</author><pubDate>Fri, 28 Aug 2009 10:08:00 +0800</pubDate><description><![CDATA[1.V$LOGFILE.STATUS    (http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1152.htm#sthref3730)  类型：VARCHAR2(7)   Status of the log member:   1.INVALID - File is inaccessible(文件不可访]]></description><category></category></item><item><title><![CDATA[定义可延迟（deferrable）的约束 ]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/4482698</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/4482698</guid><author>binhe521</author><pubDate>Tue, 25 Aug 2009 13:06:00 +0800</pubDate><description><![CDATA["定义为可延迟（deferrable）的约束可以指定为：　　1. initially immediate（初始化立即执行）或　　2. initially deferred（初始化延迟执行）。"　　我知道什么是延迟约束，但不明白什么叫"初始化立即执行的可延迟约束"和"初始化延迟执行的可延迟约束"。请解释二者的区别。还有，这些约束有什么用途？这是通常容易混淆的问题。我希望下面的例子能解释清楚。初始化立]]></description><category></category></item><item><title><![CDATA[一个查看MSSQL数据库中所有表信息的SQL语句]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/4333516</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/4333516</guid><author>binhe521</author><pubDate>Thu, 09 Jul 2009 10:56:00 +0800</pubDate><description><![CDATA[SELECT        (case when a.colorder=1 then d.name else  end)表名,       a.colorder 字段序号,       a.name 字段名,       (case when COLUMNPROPERTY( a.id,a.name,IsIdentity)=1 then √else  end) 标识,       (]]></description><category></category></item><item><title><![CDATA[sp_MSforeachtable 使用方法]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/4330299</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/4330299</guid><author>binhe521</author><pubDate>Wed, 08 Jul 2009 10:34:00 +0800</pubDate><description><![CDATA[1)说明系统存储过程sp_MSforeachtable和sp_MSforeachdb,是微软提供的两个不公开的存储过程,从ms sql 6.5开始。存放在SQL Server的MASTER数据库中。 2)参数说明:@command1 nvarchar(2000),          --第一条运行的SQL指令@replacechar nchar(1) = N?,      --指定的占]]></description><category></category></item><item><title><![CDATA[sp_executesql介绍和使用 ]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/1380330</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/1380330</guid><author>binhe521</author><pubDate>Sun, 12 Nov 2006 18:16:00 +0800</pubDate><description><![CDATA[sp_executesql介绍和使用 sp_executesql执行可以多次重用或动态生成的 Transact-SQL 语句或批处理。Transact-SQL 语句或批处理可以包含嵌入参数。语法sp_executesql [@stmt =] stmt[    {, [@params =] N@parameter_name  data_type [,...n] }    {, [@par]]></description><category></category></item><item><title><![CDATA[删除数据库中重复的记录]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/1376981</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/1376981</guid><author>binhe521</author><pubDate>Fri, 10 Nov 2006 10:32:00 +0800</pubDate><description><![CDATA[如何按字段删除重复记录?一张表里面以两个字段为唯一字段，当几条记录的这两个字段完全相同时，需要删除重复项，如下表a b c d1 2 3 41 5 3 51 2 7 9以a、b为唯一字段，第一条和第三条的a、b完全相同，所以，需要删除第一条记录1 2 3 4 或者第三条记录1 2 7 9即如下结果：a b c d1 2 3 41 5 3 5或a b c d1 5 3 51 2 7 9请问各]]></description><category></category></item><item><title><![CDATA[按成绩排序]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/1194247</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/1194247</guid><author>binhe521</author><pubDate>Fri, 08 Sep 2006 11:54:00 +0800</pubDate><description><![CDATA[                                     ID                                    UserName                                    ClassID                                    Score   ]]></description><category></category></item><item><title><![CDATA[管理常用SQL语句]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/1179266</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/1179266</guid><author>binhe521</author><pubDate>Tue, 05 Sep 2006 11:32:00 +0800</pubDate><description><![CDATA[1. 查看数据库的版本       　　 select @@version 　　2. 查看数据库所在机器操作系统参数        　　exec master..xp_msver 　　3. 查看数据库启动的参数         　　sp_configure 　　4. 查看数据库启动时间         　　select convert(varchar(30),login]]></description><category></category></item><item><title><![CDATA[常用SQL语句技法]]></title><link>https://blog.youkuaiyun.com/binhe521/article/details/1149655</link><guid>https://blog.youkuaiyun.com/binhe521/article/details/1149655</guid><author>binhe521</author><pubDate>Thu, 31 Aug 2006 15:12:00 +0800</pubDate><description><![CDATA[下列语句部分是Mssql语句，不可以在access中使用。 　　SQL分类： 　　DDL—数据定义语言(CREATE，ALTER，DROP，DECLARE) 　　DML—数据操纵语言(SELECT，DELETE，UPDATE，INSERT) 　　DCL—数据控制语言(GRANT，REVOKE，COMMIT，ROLLBACK)　　首先,简要介绍基础语句：　　1、说明：创建数据库]]></description><category></category></item></channel></rss>