LEADER 01045nam--2200361---450- 001 990001196510203316 005 20031015131454.0 035 $a000119651 035 $aUSA01000119651 035 $a(ALEPH)000119651USA01 035 $a000119651 100 $a20031015d1974----km-y0itay0103----ba 101 0 $afre 102 $aFR 105 $a||||||||001yy 200 1 $aAdamas et Ydoine$eroman du 13. siécle$fédité par John R. Reinard 210 $aParis$cH. Champion$d1974 215 $aX, 295 p.$d19 cm 225 2 $aLes classique francais du moyen age$v51 410 0$12001$aLes classique francais du moyen age$v51 454 1$12001 461 1$1001-------$12001 676 $a843.1 700 1$aREINARD,$bJohn R.$0555929 801 0$aIT$bsalbc$gISBD 912 $a990001196510203316 951 $aII F A coll. 54/51$b95537 L.M.$cII F A 959 $aBK 969 $aUMA 979 $aSIAV1$b10$c20031015$lUSA01$h1314 979 $aPATRY$b90$c20040406$lUSA01$h1726 996 $aAdamas et Ydoine$9985176 997 $aUNISA LEADER 01207cam--2200373---450 001 990005777850203316 005 20191121120344.0 010 $a978-88-6036-739-6 035 $a000577785 035 $aUSA01000577785 035 $a(ALEPH)000577785USA01 035 $a000577785 100 $a20121109d2012----km-y0itay5003----ba 101 0 $aita 102 $aIT 105 $ay|||||||001yy 200 1 $a<> strade del lavoro$escritti sulle migrazioni$fGiuseppe Di Vittorio$ga cura di Michele Colucci 210 $aRoma$cDonzelli$d2012 215 $aXXXIX, 195 p.$d22 cm 225 2 $aSaggi$iStoria e scienze sociali 410 0$12001$aSaggi$iStoria e scienze sociali 606 0 $aLavoratori [:] Emigrati italiani$xTutela$xRuolo [dei] Sindacati$zSec. 20.$2BNCF 676 $a331.544 700 1$aDI VITTORIO,$bGiuseppe$f<1892-1957>$0239201 702 1$aCOLUCCI,$bMichele$f<1976- > 801 0$aIT$bsalbc$gISBD 912 $a990005777850203316 951 $aX.3.B. 7446$b238875 L.M.$cX.3.$d00317280 959 $aBK 969 $aUMA 979 $aPASSARO$b90$c20121109$lUSA01$h1004 979 $aPASSARO$b90$c20121109$lUSA01$h1007 996 $aStrade del lavoro$914948 997 $aUNISA LEADER 06794nam 22007455 450 001 9910300660203321 005 20200706083037.0 010 $a9781484200469 010 $a1484200462 024 7 $a10.1007/978-1-4842-0046-9 035 $a(CKB)3710000000224338 035 $a(EBL)1964858 035 $a(SSID)ssj0001338640 035 $a(PQKBManifestationID)11735570 035 $a(PQKBTitleCode)TC0001338640 035 $a(PQKBWorkID)11344387 035 $a(PQKB)10141957 035 $a(MiAaPQ)EBC1964858 035 $a(DE-He213)978-1-4842-0046-9 035 $a(iGPub)SPNA0031391 035 $a(CaSebORM)9781484200469 035 $a(PPN)180622366 035 $a(OCoLC)889970326 035 $a(OCoLC)ocn889970326 035 $a(EXLCZ)993710000000224338 100 $a20140818d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aBeginning T-SQL /$fby Kathi Kellenberger, Scott Shaw 205 $a3rd ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (480 p.) 225 1 $aThe expert's voice in SQL server 300 $aIncludes index. 311 08$a9781484200476 311 08$a1484200470 327 $aContents at a Glance; Chapter 1: Getting Started; Installing SQL Server Express Edition; Installing Books Online; Using Books Online; Using SQL Server Management Studio; Launching SQL Server Management Studio; Installing the Sample Databases; Get Started with SSMS; Summary; Chapter 2: Exploring Database Concepts; What Is SQL Server?; Databases in the Cloud; Service vs. Application; Database as Container; Data Is Stored in Tables; Data Types; Normalization; Understanding Indexes; Database Schemas; Summary; Chapter 3: Writing Simple SELECT Queries; Using the SELECT Statement 327 $aSelecting a Literal ValueRetrieving from a Table; Generating a Select-List; Mixing Literals and Column Names; Filtering Data; Adding a WHERE Clause; Using WHERE Clauses with Alternate Operators; Using BETWEEN; Using BETWEEN with NOT; Filtering on Date and Time; Using WHERE Clauses with Two Predicates; Using the IN Operator; Working with NULL; Sorting Data; Thinking About Performance; Taking Advantage of Indexes; Viewing Execution Plans; Summary; Answers to the Exercises; Solutions to Exercise 3-1: Using the SELECT Statement; Solutions to Exercise 3-2: Filtering Data 327 $aSolutions to Exercise 3-3: Using WHERE Clauses with Two PredicatesSolutions to Exercise 3-4: Working with NULL; Solutions to Exercise 3-5: Sorting Data; Chapter 4: Using Built-In Functions and Expressions; Expressions Using Operators; Concatenating Strings; Concatenating Strings and NULL; CONCAT; ISNULL and COALESCE; Concatenating Other Data Types to Strings; Using Mathematical Operators; Using String Functions; RTRIM and LTRIM; LEFT and RIGHT; LEN and DATALENGTH; CHARINDEX; SUBSTRING; CHOOSE; REVERSE; UPPER and LOWER; REPLACE; Nesting Functions; Using Date and Time Functions 327 $aGETDATE and SYSDATETIMEDATEADD; DATEDIFF; DATENAME and DATEPART; DAY, MONTH, and YEAR; CONVERT; FORMAT; DATEFROMPARTS; EOMONTH; Using Mathematical Functions; ABS; POWER; SQUARE and SQRT; ROUND; RAND; Logical Functions and Expressions; The CASE Expression; Simple CASE; Searched CASE; Listing a Column as the Return Value; IIF; COALESCE; Administrative Function s; Using Functions in the WHERE and ORDER BY Clauses; The TOP Keyword; Thinking About Performance; Summary; Answers to the Exercises; Solutions to Exercise 4-1: Expressions Using Operators 327 $aSolutions to Exercise 4-2: Using Mathematical OperatorsSolution to Exercise 4-3: Using Functions; Solution to Exercise 4-4: Using Date and Time Functions; Solution to Exercise 4-5: Using Mathematical Functions; Solution to Exercise 4-6: Using Logical and System Functions; Solution to Exercise 4-7: Using Functions in the WHERE and ORDER BY Clauses; Chapter 5: Joining Tables; Using INNER JOIN; Joining Two Tables; Avoiding an Incorrect Join Condition; Joining on a Different Column Name; Joining on More Than One Column; Joining Three or More Tables; Using OUTER JOIN; Using LEFT OUTER JOIN 327 $aUsing RIGHT OUTER JOIN 330 $aBeginning T-SQL is a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server database engine. T-SQL is essential in writing SQL statements to get data into and out of a database. T-SQL is the foundation for business logic embedded in the database in the form of stored procedures and functions. Beginning T-SQL starts you on the path to mastering T-SQL, with an emphasis on best-practices and sound coding techniques leading to excellent performance. This new edition is updated to cover the essential features of T-SQL found in SQL Server 2014, 2012, and 2008. Beginning T-SQL begins with an introduction to databases, normalization, and to SQL Server Management Studio. Attention is given to Azure SQL Database and how to connect to remote databases in the cloud. Each subsequent chapter teaches an aspect of T-SQL, building on the skills learned in previous chapters. Exercises in most chapters provide an opportunity for the hands-on practice that leads to true learning and distinguishes the competent professional. Important techniques such as windowing functions are covered to help write fast executing queries that solve real business problems. A stand-out feature in this book is that most chapters end with a "Thinking About Performance" section. These sections cover aspects of query performance relative to the content just presented. They'll help you avoid beginner mistakes by knowing about and thinking about performance from Day 1. Imparts best practices for writing T-SQL Helps you avoid common errors Shows how to write scalable code for good performance. 410 0$aExpert's voice in SQL server. 606 $aDatabase management 606 $aData structures (Computer science) 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aData Structures and Information Theory$3https://scigraph.springernature.com/ontologies/product-market-codes/I15009 615 0$aDatabase management. 615 0$aData structures (Computer science) 615 14$aDatabase Management. 615 24$aData Structures and Information Theory. 676 $a004 676 $a005.74 700 $aKellenberger$b Kathi$4aut$4http://id.loc.gov/vocabulary/relators/aut$0879538 702 $aShaw$b Scott$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300660203321 996 $aBeginning T-SQL$92012829 997 $aUNINA