宾馆住宿管理系统设计与开发-本科毕业设计(论文)外文翻译文献.docVIP

本科毕业设计（论文）外文翻译 论文题目： 宾馆住宿管理系统设计与开发 学 生 姓 名： 学 号： 二级学院名称： 专 业： 指 导 教 师： 职 称： . 填表日期： 年 月 日 要求翻译与毕业设计（论文）相关的外文文献两篇，且3000单词以上/ 篇，将译文附在原文之后） (注意：外文翻译正文的字体字号行间距等格式要求，均按照论文正文的格式要求) 第一篇： [ 所译外文资料： ①作者：Paul Nielsen ②书名（或论文题目）：SQL Server 2005 Bible ③出版社（或刊物名称或可获得地址）：Wilcy Publishing,Inc ④出版时间（或卷期号）：2006016151 ⑤所译起止页码：] 原文：（建议用网上下载的PDF电子文档直接打印，即尽量保持论文原貌） Operators While the meaning of many of these expression constants, operators, and expressions is obvious and common to other programming languages, a few deserve special mention: ? The Modulo mathematical operator (%) returns only the remainder of the division. The floor() (that’s “deck” for sailors) and ceiling() mathematical functions, which return the integer rounded down or up, are related to it. The floor() function is the SQL Server equivalent of the Basic int() function: SELECT 15%4 as Modulo, FLOOR(1.25) as [Floor], CEILING(1.25) as [Ceiling] Result: Modulo Floor Ceiling ----------- ----- ------- 3 1 2 ? The + operator is used for both mathematical expressions and string concatenation. This operator is different from the MS-DOS symbol for string concatenation, the ampersand (): SELECT 123 + 456 as Addition, ?abc? + ?defg? as Concatenation Result: Addition Concatenation ----------- ------------- 579 abcdefg Data from table columns and string literals may be concatenated to return custom data: Select ?Product: ? + ProductName as [Product] From Product Result: Product --------------------------------- Product: Basic Box Kite 21 inch Product: Dragon Flight Product: Sky Dancer ... Bitwise Operators The bitwise operators are useful for binary manipulation. These aren’t typically used in transactional databases, but they can prove useful for certain metadata operations. For example, o