<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[aspxlover1的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/aspxlover1</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; aspxlover1]]></copyright><item><title><![CDATA[面试题目20090508心灵海]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/9616613</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/9616613</guid><author>aspxlover1</author><pubDate>Mon, 29 Jul 2013 15:10:07 +0800</pubDate><description><![CDATA[一、 数据库 

T表：（字段：ID，NAME，ADDRESS，PHONE，LOGDATE） 

E表：（字段：NAME，ADDRESS，PHONE） 

Q1． 将表T中的字段LOGDATE中为2001-02-11的数据更新为2003-01-01，请写出相应的SQL语句。（该字段类型为日期类型） 

A :UPDATE T SET LOGDATE ='2003-01-01' WH]]></description><category></category></item><item><title><![CDATA[面试题目20130725 成都原点科技]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/9469253</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/9469253</guid><author>aspxlover1</author><pubDate>Thu, 25 Jul 2013 15:22:26 +0800</pubDate><description><![CDATA[Q:用递归写2的N次方
A:
Q: 什么是队列什么是堆栈,他们的区别是什么?
A:
Q: 查出学生表(Student)中按名字(user_name)排序的50到60条记录
A:SELECT [user_name] FROM (
	SELECT  row_number() over(order by user_name) as idx,[user_name]
	FROM [Student]]]></description><category></category></item><item><title><![CDATA[面试题目20130724 成都闻通通信]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/9463695</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/9463695</guid><author>aspxlover1</author><pubDate>Thu, 25 Jul 2013 08:59:40 +0800</pubDate><description><![CDATA[Q : 学生表(Student)中有编号（ID）和姓名（studentName),删除学生表中重复的记录，删除时保留ID较小的一条。
A: 答案一 ：
DELETE FROM a FROM Student as a
INNER JOIN Student as b
ON a.StudentName = b.StudentName and a.ID > b.ID
答案二：
DELETE FRO]]></description><category></category></item><item><title><![CDATA[面试题目20130722 瞬联软件]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/9446107</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/9446107</guid><author>aspxlover1</author><pubDate>Thu, 25 Jul 2013 07:49:03 +0800</pubDate><description><![CDATA[机试题:
Q: 有两个数组int[] ar1={1,9,3,8,2} int ar2[] ={3,-2,8,7,10},请将其合并到一个数组并排序后输出.
A:             int[] arrResult = new int[ar1.Length + ar2.Length]; Array.Copy(ar1, arrResult, ar1.Length); Array.Copy(ar]]></description><category></category></item><item><title><![CDATA[C#位运算 示例]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/6100934</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/6100934</guid><author>aspxlover1</author><pubDate>Mon, 27 Dec 2010 16:30:00 +0800</pubDate><description><![CDATA[<br /><br />在C#中可以对整型运算对象按位进行逻辑运算。按位进行逻辑运算的意义是：依次取被运算对象的每个位，进行逻辑运算，每个位的逻辑运算结果是结果值的每个位。<br /> <br />C#支持的位逻辑运算符如下表所示。<br /><br /> <br />运算符号 意义 运算对象类型 运算结果类型 对象数 实例<br /><br />~ 位逻辑非运算 整型，字符型 整型 1 ~a<br /><br />& 位逻辑与运算 2 a & b<br /><br />| 位逻辑或运算 2 a | b<b]]></description><category></category></item><item><title><![CDATA[VBA中如何获取当前登录用户名]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/6080281</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/6080281</guid><author>aspxlover1</author><pubDate>Thu, 16 Dec 2010 15:47:00 +0800</pubDate><description><![CDATA[<br /><br />‘API调用<br />Private Declare Function GetUserName Lib "advapi32.dll" Alias "GetUserNameA" _<br />    (ByVal lpBuffer As String, nSize As Long) As Long<br /> <br />’转成VBA里常规的字符<br /><br />Public Function NTDomainUserName() As String<br /> <br /> ]]></description><category></category></item><item><title><![CDATA[数据库面试题sql查大于平均值的列]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/4992601</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/4992601</guid><author>aspxlover1</author><pubDate>Sat, 12 Dec 2009 16:15:00 +0800</pubDate><description><![CDATA[表：salesID NAME     SALES----- ---- ---------    1 a          132    2 a          143    3 b          150    4 b          198    5 a          150    6 c          150    7 c          135    8 c         ]]></description><category></category></item><item><title><![CDATA[明天去面试]]></title><link>https://blog.youkuaiyun.com/aspxlover1/article/details/4980710</link><guid>https://blog.youkuaiyun.com/aspxlover1/article/details/4980710</guid><author>aspxlover1</author><pubDate>Thu, 10 Dec 2009 17:05:00 +0800</pubDate><description><![CDATA[终于结束了无聊的“网管”工作。明天面试去了]]></description><category></category></item></channel></rss>