LEADER 05590nam 22007453u 450 001 9910461589803321 005 20210111132958.0 010 $a1-283-94101-5 010 $a1-118-22388-8 035 $a(CKB)2670000000177308 035 $a(EBL)818034 035 $a(OCoLC)787842570 035 $a(SSID)ssj0000661079 035 $a(PQKBManifestationID)12309351 035 $a(PQKBTitleCode)TC0000661079 035 $a(PQKBWorkID)10710705 035 $a(PQKB)10305568 035 $a(CaSebORM)9781118102282 035 $a(MiAaPQ)EBC818034 035 $a(EXLCZ)992670000000177308 100 $a20130418d2012|||| u|| | 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning Microsoft SQL Server 2012 Programming$b[electronic resource] 205 $a1st edition 210 $aNew York $cWiley$d2012 215 $a1 online resource (866 p.) 300 $aDescription based upon print version of record. 311 $a1-118-10228-2 327 $aBeginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults 327 $aUser-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) 327 $aSQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement 327 $aChanging What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables 327 $aObject Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints 327 $aForeign Key Constraints 330 $aGet up to speed on the extensive changes to the newest release of Microsoft SQL Server The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly 606 $aClient/server computing 606 $aDatabase management 606 $aRelational databases 606 $aSQL server 606 $aClient/server computing 606 $aEngineering & Applied Sciences$2HILCC 606 $aComputer Science$2HILCC 608 $aElectronic books. 615 4$aClient/server computing. 615 4$aDatabase management. 615 4$aRelational databases. 615 4$aSQL server. 615 0$aClient/server computing 615 7$aEngineering & Applied Sciences 615 7$aComputer Science 676 $a004.36 676 $a005.7585 700 $aAtkinson$b Paul$c(Software engineer)$028015 701 $aVieira$b Robert$0848575 801 0$bAU-PeEL 801 1$bAU-PeEL 801 2$bAU-PeEL 906 $aBOOK 912 $a9910461589803321 996 $aBeginning Microsoft SQL Server 2012 Programming$91895371 997 $aUNINA LEADER 04825nam 2200757 450 001 9910511728503321 005 20180613002611.0 010 $a90-272-6825-8 035 $a(CKB)3710000000437781 035 $a(EBL)2077073 035 $a(SSID)ssj0001517111 035 $a(PQKBManifestationID)12622230 035 $a(PQKBTitleCode)TC0001517111 035 $a(PQKBWorkID)11499789 035 $a(PQKB)11411594 035 $a(PQKBManifestationID)16037796 035 $a(PQKB)24983167 035 $a(MiAaPQ)EBC2077073 035 $a(DLC) 2015023123 035 $a(EXLCZ)993710000000437781 100 $a20150609h20152015 uy| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aFunctional categories in three Atlantic creoles $eSaramaccan, Haitian and Papiamentu /$fClaire Lefebvre, Universite? du Que?bec a? Montre?al 210 1$aAmsterdam ;$aPhiladelphia :$cJohn Benjamins Publishing Company,$d[2015] 210 4$d©2015 215 $a1 online resource (404 p.) 225 1 $aCreole Language Library,$x0920-9026 ;$v50 300 $aDescription based upon print version of record. 311 $a90-272-5274-2 320 $aIncludes bibliographical references and index. 327 $aFunctional Categories in Three Atlantic Creoles; Editorial page; Title page; LCC data; Dedication page; Table of contents; Preface; List of abbreviations; 1. Introduction; 1. Aims of this book; 2. A coherent set; 3. General methodological considerations; 4. Relabeling; 5. How is word order established in creole genesis?; 6. Processes that play a role in the development of a creole; 7. The issue of multifunctionality; 8. Organization of the book; 9. Overview of the major findings; 2. The nominal structures of Saramaccan, Fongbe and English with reference to Haitian Creole; 1. Introduction 327 $a1.1 Aim of this chapter1.2 Languages; 1.3 Theoretical framework; 1.4 Introduction to the nominal structures of the languages under comparison; 1.5 A relabeling-based account of Creole genesis; 1.6 Multifunctionality; 1.7 Data base; 1.8 Methodological provisos; 1.9 Organisation of the chapter; 2. The definite determiners; 2.1 The anaphoric property of the definite determiners; 2.2 The definite determiners in clause structures; 2.2.1 The definite determiners in relative clauses; 2.2.2 The definite determiners in factive clauses; 2.2.3 The definite determiners in temporal and causal clauses 327 $a2.2.4 The definite determiners in simple clauses2.3 A monosemic approach to Saramaccan di?; 2.2.5 The relationship between determiners and tense in clauses; 2.2.6 Summary; 2.4 The source of the properties of the Saramaccan definite determiner; 2.5 Conclusion; 3. The expression and the properties of the category Number; 3.1 The expression of the category Number and noun omission; 3.2 The conceptual role of the category Number; 3.3 The category Number and the third person plural personal pronoun; 3.4 Are Saramaccan di? and de?e? part of the same paradigm? 327 $a6. Coordinating construction in Haitian Creole 330 $aThis chapter discusses the material presented in this book organized around the various themes announced in the Introduction, and it addresses questions and comments pertinent to the issues related to these themes. The first theme to be addressed is the question of the similarity between the subsystems of functional categories between the three creoles. The second theme relates to the processes at work in the formation of the functional categories of these three creoles. Relabeling, grammaticalization and leveling will be discussed in turn. A discussion of phenomena, such as restructuring and 410 0$aCreole language library ;$vv. 50. 606 $aCreole dialects$zCaribbean Area 606 $aLanguages in contact$zCaribbean Area 606 $aCreole dialects$xSaramaccan language 606 $aCreole dialects$xHaitian 606 $aCreole dialects$xPapiamentu 606 $aBilingualism$xCaribbean Area 606 $aMinimalist theory (Linguistics) 606 $aSociolinguistics$zCaribbean Area 608 $aElectronic books. 615 0$aCreole dialects 615 0$aLanguages in contact 615 0$aCreole dialects$xSaramaccan language. 615 0$aCreole dialects$xHaitian. 615 0$aCreole dialects$xPapiamentu. 615 0$aBilingualism$xCaribbean Area. 615 0$aMinimalist theory (Linguistics) 615 0$aSociolinguistics 676 $a417.2209729 700 $aLefebvre$b Claire$0174578 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910511728503321 996 $aFunctional categories in three Atlantic creoles$92552656 997 $aUNINA