MARC Record from marc_columbia

LEADER: 07846cam a2200553Ma 4500
001 4243152
005 20220827225054.0
006 m o d
007 cr cn|||||||||
008 001201s1999 caua o 001 0 eng d
010 $z 00267561
035 $a(OCoLC)ocm45729649
035 $a(NNC)4243152
040 $aN$T$beng$epn$cN$T$dOCL$dOCLCQ$dOCLCG$dOCLCQ$dTUU$dOCLCQ$dTNF$dOCLCQ$dZCU$dOCLCO$dOCLCF$dOCLCQ$dN$T$dOCLCQ$dMWM$dOCLCQ$dSUR$dOCLCQ$dSAV$dOCLCQ$dQT7$dLUE$dOCLCQ$dWRM$dOCLCQ$dINT$dOCLCQ$dTOF$dWYU$dOCLCQ$dXMC$dPTL$dINARC$dOCLCO$dANO$dOCLCA
015 $aGB99-35592
019 $a532733300$a758975574$a970797262$a984879772$a1007405534$a1038630523$a1052977857$a1066579131$a1105736837$a1123227260$a1127915581$a1135418114$a1188975486$a1200617011
020 $a1565929799$q(electronic bk.)
020 $a9781565929791$q(electronic bk.)
020 $z1565924010
020 $a9781565924017
020 $a1565924010
035 $a(OCoLC)45729649$z(OCoLC)532733300$z(OCoLC)758975574$z(OCoLC)970797262$z(OCoLC)984879772$z(OCoLC)1007405534$z(OCoLC)1038630523$z(OCoLC)1052977857$z(OCoLC)1066579131$z(OCoLC)1105736837$z(OCoLC)1123227260$z(OCoLC)1127915581$z(OCoLC)1135418114$z(OCoLC)1188975486$z(OCoLC)1200617011
050 4 $aQA76.73.S67$bK555 1999eb
072 7 $aCOM$x051170$2bisacsh
082 04 $a005.75/6$221
049 $aZCUA
100 1 $aKline, Kevin,$d1966-
245 10 $aTransact-SQL programming /$cKevin Kline, Lee Gould, and Andrew Zanevsky.
260 $aSebastopol :$bO'Reilly,$c1999.
300 $a1 online resource (xxvi, 807 pages) :$billustrations
336 $atext$btxt$2rdacontent
337 $acomputer$bc$2rdamedia
338 $aonline resource$bcr$2rdacarrier
500 $aIncludes index.
520 $aProvides detailed information about Transact-SQL programming and shows specific differences between the Microsoft and Sybase versions of the language.
588 0 $aPrint version record.
504 $aIncludes index.
505 00 $g1.$tThe Basics: Programming in Transact-SQL$g1 --$tSQL and the Introduction of Transact-SQL$g3 --$tThe Relational Database Model$g4 --$tNormalization$g6 --$tRow Processing Versus Set Processing$g13 --$tThe History of SQL Server$g14 --$tWhat Is Transact-SQL?$g16 --$g2.$tDatabase Analysis and Design$g28 --$tThe Need for Adequate Analysis and Design$g28 --$tThe Systems Life Cycle$g29 --$tOverview of Analysis$g31 --$tOverview of Design$g34 --$tPutting it Together with CASE Technology$g38 --$g3.$tSQL Primer$g51 --$tSQL Versus Transact-SQL$g51 --$tData Definition Language$g52 --$tData Manipulation Language$g76 --$g4.$tTransact-SQL Fundamentals$g120 --$tServer Character Sets$g120 --$tServer Sort Orders$g121 --$tIdentifiers$g125 --$tFoundation Units$g127 --$tExecuting Transact-SQL$g136 --$tThe GO Statement$g143 --$tTransact-SQL Batches$g144 --$g5.$tFormat and Style$g147 --$tWhy Bother?$g147 --$tWhat Is a Good Coding Style?$g149 --$tCase of Keywords and User-Defined Names$g153 --$tNaming Conventions and Abbreviations$g155 --$tStandard Error Handling$g160 --$tStyle Odds and Ends$g161 --$tFormatting DML and DDL Statements$g164 --$tFormatting Transaction Blocks and Procedural Blocks$g168 --$tCommenting Your Code$g171 --$gII.$tThe Building Blocks: Transact-SQL Language Elements$g175 --$g6.$tDatatypes and Variables$g177 --$tDatatypes$g177 --$tUser-Defined Datatypes$g189 --$tProcessing Nulls$g191 --$tVariables$g192 --$tParameters$g203 --$g7.$tConditional Processing$g209 --$tBEGIN . . . END Constructs$g210 --$tIF Constructs$g211 --$tGOTO Branching and Error Handling$g218 --$tWAITFOR Construct$g219 --$tWHILE Loops$g222 --$tRETURN Statement$g227 --$g8.$tRow Processing with Cursors$g230 --$tCursor Fundamentals$g231 --$tDeclaring a Cursor$g232 --$tOpening a Cursor$g234 --$tAsynchronous Keysets$g235 --$tFetching Data$g237 --$tClosing and Deallocating a Cursor$g241 --$tWorking with Cursors$g242 --$tPerformance Issues for Cursors$g247 --$g9.$tError Handling$g256 --$tCode Processing and Error Handling: Basic Concepts$g256 --$tDisplaying an Error Message with PRINT$g257 --$tRaising an Error with RAISERROR$g259 --$tFinding Error Conditions with Global Variables$g268 --$tHandling Errors with GOTO$g269 --$tCreating Specialized Error Messages$g270 --$tFinding Error Messages in Operating System Files$g271 --$g10.$tTemporary Objects$g274 --$tCreating and Manipulating Temporary Objects$g275 --$tThe tempdb Database$g276 --$tClasses of Temporary Objects$g277 --$tQuery Optimization with Temporary Tables$g292 --$tManagement of the tempdb Database$g293 --$g11.$tTransactions and Locking$g297 --$tAbout Transactions$g298 --$tLocking$g309 --$tTransactions and the Database$g333 --$gIII.$tFunctions and Extensions$g347 --$g12.$tFunctions$g349 --$tAggregate Functions$g353 --$tMathematical Functions$g359 --$tString Functions$g366 --$tDate Functions$g381 --$tText and Image Functions$g385 --$tType Conversion Functions$g386 --$tSystem Functions$g396 --$g13.$tCASE Expressions and Transact-SQL Extensions$g414 --$tCASE Expressions$g414 --$tCOMPUTE$g421 --$tCUBE and ROLLUP$g424 --$gIV.$tProgramming Transact-SQL Objects$g435 --$g14.$tStored Procedures and Modular Design$g437 --$tAbout Stored Procedures$g438 --$tCREATE PROCEDURE$g438 --$tTypes of Stored Procedures$g450 --$tAdvantages of Stored Procedures$g454 --$tStored Procedures Versus Other Objects$g454 --$tExecuting Stored Procedures$g456 --$tRemote Procedure Calls (RPCs)$g459 --$tStored Procedure Design$g465 --$tConditional Data Retrieval$g470 --$tData Formatting$g472 --$tData Security and Encryption$g476 --$tPerformance Issues$g484 --$g15.$tTriggers and Constraints$g489 --$tTriggers$g489 --$tInteraction of Triggers and Constraints$g500 --$g16.$tViews$g503 --$tAbout Views$g503 --$tManaging Views$g504 --$tQuerying Views$g509 --$tView Dependencies, Permissions, and Data Manipulations$g520 --$tLimitations of Views$g524 --$tView Overhead$g525 --$g17.$tSystem and Extended Stored Procedures$g527 --$tSystem Stored Procedures$g527 --$tCommon System Stored Procedures$g528 --$tExtended Stored Procedures$g558 --$gV.$tPerformance Tuning and Optimization$g567 --$g18.$tTransact-SQL Code Design$g569 --$tCoding for Reuse$g569 --$tThe Black Box Program$g571 --$tCategorization Schemas$g574 --$tRETURN$g578 --$tRAISERROR$g578 --$tTemporary Data Storage$g578 --$tUsing Parameters Effectively$g582 --$tHelp$g583 --$g19.$tCode Maintenance in SQL Server$g586 --$tUsing SQL Server System Tables$g586 --$tInterdependence of Server-Side Objects$g589 --$tSource Code Management$g590 --$tCode Maintenance$g598 --$tRelated Topics$g602 --$g20.$tTransact-SQL Optimization and Tuning$g604 --$tAbout Optimization$g605 --$tEfficient Physical Database Design$g608 --$tIndexing Strategies$g612 --$tSQL Server Query Optimizer$g619 --$tSHOWPLAN Output$g625 --$tOptimizer Hints$g632 --$tQuery Analysis$g638 --$tOptimization Tips and Techniques$g652 --$g21.$tDebugging Transact-SQL Programs$g672 --$tTesting Versus Debugging$g672 --$tSuccessful Debugging$g673 --$tSpecific Debugging Techniques$g680 --$tThe SET Command$g705 --$tDebugging Utilities$g716 --$gA.$tSystem Tables$g721 --$gB.$tWhat's New for Transact-SQL in Microsoft SQL Server 7.0$g743 --$gC.$tThe BCP Utility$g779.
650 0 $aSQL (Computer program language)
650 6 $aSQL (Langage de programmation)
650 7 $aCOMPUTERS$xProgramming Languages$xSQL.$2bisacsh
650 7 $aSQL (Computer program language)$2fast$0(OCoLC)fst01102869
655 0 $aElectronic book.
655 4 $aElectronic books.
700 1 $aGould, Lee.
700 1 $aZanevsky, Andrew.
776 08 $iPrint version:$aKline, Kevin E., 1966-$tTransact-SQL programming.$dSebastopol : O'Reilly, 1999$z1565924010$w(DLC) 00267561$w(OCoLC)41388930
856 40 $uhttp://www.columbia.edu/cgi-bin/cul/resolve?clio4243152$zAll EBSCO eBooks
852 8 $blweb$hEBOOKS