Titlebook: Beginning SQL Server 2000 Programming; Robin Dewson Book 20011st edition Robin Dewson 2001 SQL.SQL Server 2000.XML.design.development.prog

吹牛需要艺术

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

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

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

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

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

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

abnegate

Cardiac

https://doi.org/10.1007/978-1-4302-0804-4SQL; SQL Server 2000; XML; design; development; programming; relational database

jabber

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.