The Resource Pro T-SQL 2012 programmer's guide, Jay Natarajan...[et al.], (electronic resource)

Pro T-SQL 2012 programmer's guide, Jay Natarajan...[et al.], (electronic resource)

Label
Pro T-SQL 2012 programmer's guide
Title
Pro T-SQL 2012 programmer's guide
Statement of responsibility
Jay Natarajan...[et al.]
Contributor
Author
Provider
Subject
Language
eng
Summary
Pro T–SQL 2012 Programmer’s Guide is every developer’s key to making full use of SQL Server 2012’s powerful, built–in Transact–SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact–SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact–SQL into your own hands. Step–by–step explanations ensure clarity, and an advocacy of best–practices will steer you down the road to success. Transact–SQL is the language developers and DBAs use to interact with SQL Server. It’s used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks
Cataloging source
GW5XE
Image bit depth
0
LC call number
QA76.73.S67
LC item number
C653 2012eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorDate
1972-
http://library.link/vocab/relatedWorkOrContributorName
  • SpringerLink
  • Coles, Michael
http://library.link/vocab/subjectName
  • SQL (Computer program language)
  • SQL (Computer program language)
Label
Pro T-SQL 2012 programmer's guide, Jay Natarajan...[et al.], (electronic resource)
Instantiates
Publication
Note
Includes index
Antecedent source
mixed
Color
not applicable
Contents
  • Data Types and Advanced Data Types
  • Full-Text Search
  • XML
  • XQuery and XPath
  • Catalog Views and Dynamic Management Views
  • CLR Integration Programming
  • .NET Client Programming
  • Data Services
  • Error Handling and Dynamic SQL
  • Performance Tuning
  • Foundations of T-SQL
  • Tools of the Trade
  • Procedural Code and CASE Expressions
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Encryption
  • Common Table Expressions and Windowing Functions
Dimensions
unknown
Edition
3rd ed.
Extent
1 online resource (xxxiv, 659 p.)
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781430245971
Level of compression
uncompressed
Other physical details
ill.
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
  • (OCoLC)820954217
  • (OCoLC)ocn820954217
Label
Pro T-SQL 2012 programmer's guide, Jay Natarajan...[et al.], (electronic resource)
Publication
Note
Includes index
Antecedent source
mixed
Color
not applicable
Contents
  • Data Types and Advanced Data Types
  • Full-Text Search
  • XML
  • XQuery and XPath
  • Catalog Views and Dynamic Management Views
  • CLR Integration Programming
  • .NET Client Programming
  • Data Services
  • Error Handling and Dynamic SQL
  • Performance Tuning
  • Foundations of T-SQL
  • Tools of the Trade
  • Procedural Code and CASE Expressions
  • User-Defined Functions
  • Stored Procedures
  • Triggers
  • Encryption
  • Common Table Expressions and Windowing Functions
Dimensions
unknown
Edition
3rd ed.
Extent
1 online resource (xxxiv, 659 p.)
File format
multiple file formats
Form of item
  • online
  • electronic
Isbn
9781430245971
Level of compression
uncompressed
Other physical details
ill.
Quality assurance targets
absent
Reformatting quality
access
Specific material designation
remote
System control number
  • (OCoLC)820954217
  • (OCoLC)ocn820954217

Library Locations

  • African Studies LibraryBorrow it
    771 Commonwealth Avenue, 6th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Alumni Medical LibraryBorrow it
    72 East Concord Street, Boston, MA, 02118, US
    42.336388 -71.072393
  • Astronomy LibraryBorrow it
    725 Commonwealth Avenue, 6th Floor, Boston, MA, 02445, US
    42.350259 -71.105717
  • Fineman and Pappas Law LibrariesBorrow it
    765 Commonwealth Avenue, Boston, MA, 02215, US
    42.350979 -71.107023
  • Frederick S. Pardee Management LibraryBorrow it
    595 Commonwealth Avenue, Boston, MA, 02215, US
    42.349626 -71.099547
  • Howard Gotlieb Archival Research CenterBorrow it
    771 Commonwealth Avenue, 5th Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Mugar Memorial LibraryBorrow it
    771 Commonwealth Avenue, Boston, MA, 02215, US
    42.350723 -71.108227
  • Music LibraryBorrow it
    771 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350723 -71.108227
  • Pikering Educational Resources LibraryBorrow it
    2 Silber Way, Boston, MA, 02215, US
    42.349804 -71.101425
  • School of Theology LibraryBorrow it
    745 Commonwealth Avenue, 2nd Floor, Boston, MA, 02215, US
    42.350494 -71.107235
  • Science & Engineering LibraryBorrow it
    38 Cummington Mall, Boston, MA, 02215, US
    42.348472 -71.102257
  • Stone Science LibraryBorrow it
    675 Commonwealth Avenue, Boston, MA, 02445, US
    42.350103 -71.103784
Processing Feedback ...