官术网_书友最值得收藏!

  • SQL Server 2016 Developer's Guide
  • Dejan Sarka Milo? Radivojevi? William Durkin
  • 415字
  • 2021-07-09 19:05:40

Chapter 2. Review of SQL Server Features for Developers

Before delving into the new features in SQL Server 2016, let's have a quick recapitulation of the features of SQL Server for developers already available in the previous versions of SQL Server. Recapitulating the most important features will help you remember what you already have in your development toolbox and also understand the need and the benefits of the new or improved features in SQL Server 2016.

Tip

This chapter has a lot of code. As this is not a book for beginners, the intention of this chapter is not to teach you the basics of database development. It is rather a reminder of the many powerful and efficient Transact-SQL (T-SQL) and other elements included in SQL Server version 2014 and even earlier.

The recapitulation starts with the mighty T-SQL SELECT statement. Besides the basic clauses, advanced techniques such as window functions, common table expressions, and the APPLY operator are explained. Then, you will pass quickly through creating and altering database objects, including tables and programmable objects, such as triggers, views, user-defined functions, and stored procedures. You will also review data modification language statements. Of course, errors might appear, so you have to know how to handle them. In addition, data integrity rules might require that two or more statements are executed as an atomic, inpisible block. You can achieve this with the help of transactions.

Note

Note that this chapter is not a comprehensive development guide.

The last section of this chapter deals with the parts of SQL Server Database Engine marketed with a common name: "Beyond Relational." This is nothing beyond the relational model—beyond relational is really just a marketing term. Nevertheless, you will review the following:

  • How SQL Server supports spatial data
  • How you can enhance the T-SQL language with Common Language Runtime (CLR) elements written in a .NET language, such as Visual C#
  • How SQL Server supports XML data

The code in this chapter uses the WideWorldImportersDW demo database. In order to test the code, this database must be present in the SQL Server instance you are using for testing, and you must also have SQL Server Management Studio (SSMS) as the client tool.

This chapter will cover the following points:

  • Core Transact-SQL SELECT statement elements
  • Advanced SELECT techniques
  • Data definition language statements
  • Data modification language statements
  • Triggers
  • Data abstraction: views, functions, and stored procedures
  • Error handling
  • Using transactions
  • Spatial data
  • CLR integration
  • XML support in SQL Server
主站蜘蛛池模板: SHOW| 杭锦后旗| 丰宁| 郁南县| 建宁县| 禹城市| 阜南县| 隆尧县| 库尔勒市| 犍为县| 昭通市| 巧家县| 瑞安市| 邳州市| 金昌市| 肥西县| 沾益县| 宁国市| 洛阳市| 峨山| 周口市| 彰化市| 将乐县| 汉寿县| 桑日县| 林州市| 康马县| 景泰县| 洛阳市| 凉山| 乌审旗| 治县。| 酒泉市| 琼结县| 开远市| 盐津县| 华蓥市| 华阴市| 察隅县| 南岸区| 黄大仙区|