软件_双语_Lecture8新_2011春.ppt

第8讲 Transact-SQL编程基础Transact-SQL Programming Textbook: Chapter 5: Programs to Access a Database ;本讲主要内容;SQL Server标识符;SQL Server标识符(续);完整的对象名格式;T-SQL Language Elements(T-SQL语言要素);Local Variables(局部变量);变量 ;变量;Global Variables(续);Operators(操作符);The following table shows the precedence level of operators (levels go from highest to lowest);字符串连接运算符举例;Control of Flow Language Elements(流程控制语句);流程控制语句;Control of Flow Language Elements(流程控制语句);IF…ELSE举例;IF…ELSE举例;WHILE举例;简单CASE格式举例;搜索CASE格式举例;WHILE和CASE举例;Functions(函数);Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0