摘要： （一）USE NorthwindselectOrderID,count(case when Quantity between 20 and 30 then ProductID end) as '20-30',count(case when Quantity between 30 and 40 then ProductID end) as '30-40',count(case when Quanti... 阅读全文

摘要： USE Northwinddeclare Order_cursor cursor forSELECT OrderID from Ordersopen Order_cursordeclare @OrderID as INTfetch next from Order_cursor into @OrderIDwhile(@@fetch_status =0)beginPRINT 'OrderID' + S... 阅读全文

摘要： 如果你经常关注SQL Server的NewsGroups，你会发现人们经常会问为什么我不能运行这样的SQL语句：SELECT * FROM @tablenameSELECT @colname FROM tblSELECT * FROM tbl WHERE x IN (@list)In many cases someone says "use dynamic SQL" and with a simp... 阅读全文

摘要： 选择从10到15的记录select top 5 * from (select top 15 * from table order by id asc) table_别名 order by id desc　　随机选择数据库记录的方法（使用Randomize函数，通过SQL语句实现）　　对存储在数据库中的数据来说，随机数特性能给出上面的效果，但它们可能太慢了些。你不能要求ASP“找个随机数... 阅读全文

摘要： 查询系统表INFORMATION_SCHEMA.TABLES得到所有用户表结构：SELECT T.TABLE_SCHEMA as [TableOwner],T.TABLE_NAME as [TableName],C.COLUMN_NAME as [ColumnName],C.DATA_TYPE as [DataType],C.CHARACTER_MAXIMUM_LENGTH as [Size],C... 阅读全文

摘要： 1.在线辞典翻译类： 万物大辞典：http://qingdaonet.org/dic/menu.htmJEDLINE 和英辞書 (医歯薬篇)： http://www.medo.jp/0.htmGoo在线日英英日国語辞典：http://www.goo.ne.jp Excite在线翻译、辞典：http://www.excite.co.jp infoseekマルチ辞書： http://www.infos... 阅读全文

摘要： Gmail Smtp has 2 ports exposed 465 and 587. 465 port is for Exchange structre and thats why the Smtp protocol doesnt work against it. We have testcases internally that try to send mail to port 587 of ... 阅读全文

摘要： 英文写作网 （ www.4ewriting.com ）提供英文写作的各种相关技巧，主要内容包括写作语法文法、应用写作、考试作文、写作范文、背景文化 佳作欣赏、原创发表、英文blog、英语笔友、名师指导、写作论坛等。1. 英语学习：英语学习频道(VOA Special English)http://www.unsv.com/博客英语网http://www.ensalon.com/enradio/en... 阅读全文

摘要： 算法常用术语中英对照 Data Structures 基本数据结构 Dictionaries 字典 Priority Queues 堆 Graph Data Structures 图 Set Data Structures 集合 Kd-Trees 线段树 Numerical Problems 数值问题 Solving Linear Equations 线性方程组 Bandwidth Redu... 阅读全文

摘要： I feel blue today and I'm very tired. The OutlookSync VSTO project can't be deploy on the user computer. Just becaust the VSTO2005 didn't grant trust to my code assembly by default. It's very shit. 阅读全文