吹牛需要艺术 发表于 2025-3-28 18:33:30
Iatrogenic Disorders of the Esophagus,Chapter 17 introduced stored procedures and provided the basic syntax for their use as well as some simple examples. Stored procedures encompass quite a bit more and deserve some additional attention. The syntax allows for sophisticated construction of related, interdependent operations as well as graceful error control.Disk199 发表于 2025-3-28 19:53:02
Creating the Sample Database,By now we should know our way around SQL Server and its components that make it easy to use and understand. It’s now time we started building our example application.averse 发表于 2025-3-29 01:07:01
Defining Tables,Now that the database is created, it obviously needs to have the ability to store information, after all, without this, what is the point of a database, and then what is the point of this book? The first area that needs to be worked on is the table definitions.Heresy 发表于 2025-3-29 05:16:08
Diagramming the Database,Now that the database has been built, tables have been created, indexes inserted have been, and relationships link some of the tables, it is time to start documenting. To help with this, SQL Server offers us the . tool, which is the topic of this chapter.endarterectomy 发表于 2025-3-29 09:57:34
Database Backups and Recovery,Now that a major part of the database has been created in the previous chapters, and before moving on to inserting and manipulating the data, this is a good point to take a moment’s breath to backup the database, just so that if things go wrong, it is possible to recover back to a stable point.Irrigate 发表于 2025-3-29 13:33:58
Retrieving Data,This chapter will demonstrate how to view the data that has been placed in the tables so far. There are many ways of achieving this, from using Enterprise Manager, through to T-SQL commands, and as you would expect, they will all be covered here.Gyrate 发表于 2025-3-29 16:05:41
http://reply.papertrans.cn/19/1826/182526/182526_47.pngabnegate 发表于 2025-3-29 23:00:50
http://reply.papertrans.cn/19/1826/182526/182526_48.pngCardiac 发表于 2025-3-30 01:37:03
https://doi.org/10.1007/978-1-4302-0804-4SQL; SQL Server 2000; XML; design; development; programming; relational databasejabber 发表于 2025-3-30 07:35:44
Managing SQL Server,ve product to use. In this chapter, the main focus will be on Enterprise Manager, which is the heart of the GUI interface between the developer — or database administrator — and the SQL Server engine. This is an easy-to-use and intuitive tool, and before long, you will feel confident in using it to work with SQL Server quickly and efficiently.