August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Using the Query Editor
With SQL Server 2005, the Query Editor carried on the legacy of SQL Server's Query Analyzer as the primary UI for database developers. In SQL Server 2008 and 2008R2, that experienced was enhanced and evolved. Now, with SQL Server 2012 it's an absolutely awesome product to work with!
Opening a Query Connecting to a Server
The Query Editor can maintain multiple open query documents and connections within the tabbed document area. Different queries may be connected as different users, which is useful for testing security. And the Query Editor can open and work with a .sql file even when not connected to a server.
When Query Editor first opens, it prompts for an initial login. To make further connections, use the File → New Connection menu command.
The New Query toolbar button opens a new Query Editor document. There's some intelligence in how it selects the current database for the new query. If the Object Explorer has focus before the New Query button is pressed, the new query connects to Object Explorer's currently selected database. If the Query Editor has focus, the new query opens to the same database as the Query Editor's current query.
You can also switch a query's connection to another server using the Query → Connection menu, the Change Connection toolbar button, or the Query Editor's context menu.
The query tab displays the most it can of the current SQL Server and database merged with the filename.
Tip
In some extreme cases, if SQL Server appears ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.