|
|
|
|
| LEADER |
05037nmm a2200433 u 4500 |
| 001 |
EB001940777 |
| 003 |
EBX01000000000000001103679 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9780470106211
|
| 020 |
|
|
|a 0470106212
|
| 050 |
|
4 |
|a QA76.9.C55
|
| 100 |
1 |
|
|a Vieira, Robert
|
| 245 |
0 |
0 |
|a Professional SQL server 2005 programming
|c Robert Vieira
|
| 260 |
|
|
|a Indianapolis, IN
|b Wiley Technology Pub.
|c 2007
|
| 300 |
|
|
|a xxvii, 884 pages
|b illustrations
|
| 505 |
0 |
|
|a Changing What You8217;ve Got with the UPDATE Statement -- The DELETE Statement -- Exploring Alternative Syntax for Joins -- The UNION -- Summary -- CH36;Chapter 458; Creating and Altering Tables -- Object Names in SQL Server -- The CREATE Statement -- The ALTER Statement -- The DROP Statement -- Using the GUI Tool -- Summary -- CH36;Chapter 558; Reviewing Keys and Constraints -- Types of Constraints -- Constraint Naming -- Key Constraints -- CHECK Constraints -- DEFAULT Constraints -- Disabling Constraints -- Rules and Defaults58; Cousins of Constraints -- Triggers for Data Integrity -- Choosing What to Use -- Summary -- CH36;Chapter 658; Asking a Better Question58; Advanced Queries -- What Is a Subquery63; -- Building a Nested Subquery -- Correlated Subqueries -- Derived Tables -- The EXISTS Operator -- Mixing Data Types58; CAST and CONVERT -- Using External Calls to Perform Complex Actions -- Performance Considerations -- Summary -- CH36;Chapter 758; Daring to Design --
|
| 505 |
0 |
|
|a Normalization 201 -- Relationships -- Diagramming -- Logical versus Physical Design -- Dealing with File45;Based Information -- Subcategories -- Database Reuse -- De45;Normalization -- Par titioning for Scalability -- The SQL Server Diagramming Tools -- Summary -- CH36;Chapter 858; SQL Server 8212; Storage and Index Structures -- SQL Server Storage -- Understanding Indexes -- Creating44; Altering44; and Dropping Indexes -- Choosing Wisely58; Deciding What Index Goes Where and When -- Maintaining Your Indexes -- Summary -- CH36;Chapter 958; Views -- Simple Views -- More Complex Views -- Editing Views with T45;SQL -- Dropping Views -- Auditing58; Displaying Existing Code -- Protecting Code58; Encrypting Views -- About Schema Binding -- Making Your View Look Like a Table with VIEW_ METADATA -- Indexed 40;Materialized41; Views -- Partitioned Views -- Summary -- CH36;Chapter 1058; Scripts and Batches -- Script Basics -- Batches -- SQLCMD --
|
| 505 |
0 |
|
|a Cover -- Credits -- About the Author -- Acknowledgments -- TOC36;Contents -- Introduction -- Version Issues -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- Feedback -- What You Need to Use This Book -- Conventions -- Source Code -- Errata -- p2p46;wrox46;com -- CH36;Chapter 158; Being Objective58; Re45;Examining Objects in SQL Server -- So44; What Exactly Do We Have Here63; -- An Overview of Database Objects -- SQL Server Data Types -- SQL Server Identifiers for Objects -- Summary -- CH36;Chapter 258; Tool Time -- Books Online -- The SQL Server Configuration Manager -- The SQL Server Management Studio -- SQL Server Business Intelligence Development Studio -- SQL Server Integration Services 40;SSIS41; -- Reporting Services -- Bulk Copy Program 40;BCP41; -- SQL Server Profiler -- sqlcmd -- Summary -- CH36;Chapter 358; Basic T45;SQL -- The Basic SELECT Statement -- Adding Data with the INSERT Statement --
|
| 505 |
0 |
|
|a Dynamic SQL58; Generating Your Code on the Fly with the EXEC Command -- Control45;of45;Flow Statements -- Summary -- CH36;Chapter 1158; Getting Procedural58; Stored Procedures and User45;Defined Functions -- Creating the Sproc58; Bas
|
| 653 |
|
|
|a Client/server computing / fast
|
| 653 |
|
|
|a SQL Server
|
| 653 |
|
|
|a Architecture client-serveur (Informatique)
|
| 653 |
|
|
|a SQL server / fast
|
| 653 |
|
|
|a REFERENCE / General / bisacsh
|
| 653 |
|
|
|a SQL server / http://id.loc.gov/authorities/names/n90684343
|
| 653 |
|
|
|a Client/server computing / http://id.loc.gov/authorities/subjects/sh93000502
|
| 653 |
|
|
|a SQL server / blmlsh
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 490 |
0 |
|
|a Wrox professional guides
|
| 776 |
|
|
|z 9780764584343
|
| 776 |
|
|
|z 0764584340
|
| 776 |
|
|
|z 0470106212
|
| 776 |
|
|
|z 9780470106211
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9780764584343/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.2/768
|
| 520 |
|
|
|a Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the?meat? of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples
|