<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ysrock的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ysrock</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ysrock]]></copyright><item><title><![CDATA[数据库移植注意事项]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1560448</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1560448</guid><author>ysrock</author><pubDate>Wed, 11 Apr 2007 14:00:00 +0800</pubDate><description><![CDATA[1.1     数据库移植注意事项1.1.1 取前n条记录       SQL Server：     Select top n * from xtable       Oracle：         Select * from xtable where rownum       DB2：            Select * from xtable fetch first n rows onl]]></description><category></category></item><item><title><![CDATA[DB2与SqlServer数据移植备忘]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1560398</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1560398</guid><author>ysrock</author><pubDate>Wed, 11 Apr 2007 13:29:00 +0800</pubDate><description><![CDATA[一、自增序列：DB2:create table TestTable( recordindex  integer identity generated as always, stringDateTime  varchar(50), TrueDateTime timestamp);SQLServer:create table TestTable( recordindex  int identity, ]]></description><category></category></item><item><title><![CDATA[返回数据库中所有表名]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1559170</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1559170</guid><author>ysrock</author><pubDate>Tue, 10 Apr 2007 15:14:00 +0800</pubDate><description><![CDATA[select   name   from   sysobjects   where   xtype=U下面的语句执行后返回的列分别是：表名、列名、列类型、列长度、列描述、是否主键，语句如下：Select Sysobjects.Name As Tb_name, Syscolumns.Name As Col_name, Systypes.Name As Col_type, Syscol]]></description><category></category></item><item><title><![CDATA[javascript基本函数]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1557761</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1557761</guid><author>ysrock</author><pubDate>Mon, 09 Apr 2007 16:07:00 +0800</pubDate><description><![CDATA[如果你找的javascript的东西的话,建议你 ctrl+F  直接在这个页上找,因为这里80%有你要找的,但是要让你挨着看的话,你就准备看完就去配眼镜!!            事件源对象 event.srcElement.tagName event.srcElement.type         捕获释放 event.srcElement.setCapture();  eve]]></description><category></category></item><item><title><![CDATA[黑客基础之DOS ]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1546280</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1546280</guid><author>ysrock</author><pubDate>Fri, 30 Mar 2007 11:00:00 +0800</pubDate><description><![CDATA[黑客基础之DOS （最齐全） -------------------------------------------------------------------------------- net use $">//ip/ipc$ " " /user:" " 建立IPC空链接 net use $">//ip/ipc$ "密码" /user:"用户名" 建立IPC非空链接 net use h: $]]></description><category></category></item><item><title><![CDATA[获取sqlserver中表名和列的信息]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1542832</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1542832</guid><author>ysrock</author><pubDate>Tue, 27 Mar 2007 14:55:00 +0800</pubDate><description><![CDATA[SELECT                   (case   when   a.colorder=1   then   d.name   else      end)表名,                 --   d.name   as   表名,                   a.colorder   字段序号,                   a.name   字段名,]]></description><category></category></item><item><title><![CDATA[mysql忘记密码的解决方法]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1514972</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1514972</guid><author>ysrock</author><pubDate>Mon, 26 Feb 2007 15:17:00 +0800</pubDate><description><![CDATA[ 解决办法：在windows下：打开命令行窗口，停止mysql服务：        Net stop mysql启动mysql，一般到mysql的安装路径，找到 mysqld-nt.exe执行：mysqld-nt --skip-grant-tables 当前窗口将会停止。另外打开一个命令行窗口，执行mysql   如果提示没有这个命令，先进入MYSQL的安装位置下BIN目录再运行mysql>use]]></description><category></category></item><item><title><![CDATA[web页面屏蔽右键菜单 左键选取]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1490168</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1490168</guid><author>ysrock</author><pubDate>Mon, 22 Jan 2007 15:57:00 +0800</pubDate><description><![CDATA[body oncontextmenu=self.event.returnValue=false onselectstart="return false">可惜能看到源代码]]></description><category></category></item><item><title><![CDATA[cmd 命令]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1490124</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1490124</guid><author>ysrock</author><pubDate>Mon, 22 Jan 2007 15:12:00 +0800</pubDate><description><![CDATA[nbtstat -a ip 相关ip地址的mac地址netstat  正在使用的端口 ]]></description><category></category></item><item><title><![CDATA[delphi progressbar使用]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1481156</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1481156</guid><author>ysrock</author><pubDate>Fri, 12 Jan 2007 14:21:00 +0800</pubDate><description><![CDATA[  ProgressBar1.Max := MyStream.Size; ProgressBar1.Position := ProgressBar1.Position + （整形变量）;]]></description><category></category></item><item><title><![CDATA[sql 标识列]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1479680</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1479680</guid><author>ysrock</author><pubDate>Wed, 10 Jan 2007 23:51:00 +0800</pubDate><description><![CDATA[参见http://www.51iter.com/program/database/sql/200604/program_30027.html 我只写我用过的部分 1、创建表时指定标识列标识列可用 IDENTITY 属性建立，因此在SQL Server中，又称标识列为具有IDENTITY属性的列或IDENTITY列。下面的例子创建一个包含名为ID,类型为int,种子为1，递增量为1的]]></description><category></category></item><item><title><![CDATA[sql 本地数据库内容写入远程数据库]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1478565</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1478565</guid><author>ysrock</author><pubDate>Tue, 09 Jan 2007 23:17:00 +0800</pubDate><description><![CDATA[在远程数据库和本地数据库中有相同结构的表--创建链接服务器exec sp_addlinkedserver  srv_lnk,,sqloledb,远程服务器名或ip地址exec sp_addlinkedsrvlogin srv_lnk,false,null,用户名,密码goinsert into srv_lnk.库名.dbo.表名(字段名1,字段名2,字段名3]]></description><category></category></item><item><title><![CDATA[c# sqlserver 连接]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1477291</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1477291</guid><author>ysrock</author><pubDate>Mon, 08 Jan 2007 16:26:00 +0800</pubDate><description><![CDATA[        string strConnection = "database = uuxi;Server = ROCK//SQLEXPRESS;integrated security=SSPI;";        SqlConnection objConnection = new SqlConnection(strConnection);        objConnection.Open]]></description><category></category></item><item><title><![CDATA[sql学习——从txt文件导入到数据库]]></title><link>https://blog.youkuaiyun.com/ysrock/article/details/1476861</link><guid>https://blog.youkuaiyun.com/ysrock/article/details/1476861</guid><author>ysrock</author><pubDate>Mon, 08 Jan 2007 11:08:00 +0800</pubDate><description><![CDATA[ create table tablename(col1 varchar(10),col2 varchar(10),col3 varchar(20),col4 varchar(10), col5 varchar(10),col6 varchar(10),col7 varchar(10),col8 varchar(10)) --导入 BULK INSERT test..tablename -]]></description><category></category></item></channel></rss>