Titlebook: Introducing SQL Server; Mike McQuillan Book 2015 Mike McQuillan 2015

消滅

Table-Valued Functions,ed functions, or TVFs for short. TVFs let you create parameterized tables, which you can use in your queries to provide extra functionality that a normal join would struggle to match. Time to talk tables again!

Receive

細(xì)胞學(xué)

flutter

在駕駛

Obtaining and Installing SQL Server,As you saw in ., there are plenty of versions of SQL Server available. We’re going to use SQL Server Express, which is completely free, as the basis of this book. Although much more limited than other versions, Express is still very powerful and includes all of the features we are going to look at during the course of the book.

A精確的

Database Basics,In this chapter, we are going to look at databases: what they are, the types available to us, and how we manage them. We’ll also take a look at some basic server settings, including security.

facetious

Putting Good Tables Together,Now that you have an idea about how tables work, we need to make sure they can store our data in a proper manner. To do this, we use a process called .. Once this has been applied to our tables, we should have an efficient database structure that minimizes duplicate data. Or to put it simply, everything should just work!

僵硬

Creating Data Import Scripts,We’ve just seen, in some detail, how the . statement can be used to import files into database tables. Unfortunately, there are some limitations with ., which meant we had to remove one of our contact records from the appropriate files.

Radiculopathy

Views,Contrary to popular opinion, a view isn’t something you see out of a window. Not in database terms, anyway. I’m afraid it’s much more mundane! A view in a database can be thought of as a virtual table. It allows you to view data in a particular way, by utilizing other database objects.

Femine

Indexes,We’ve already met indexes during our database travels to date. We were creating clustered indexes when we created primary keys, and we also created unique indexes when we created unique constraints.