國立虎尾科技大學 |

SQL Server T-SQL recipes

Record Type:	Language materials, printed : Monograph/item
Title/Author:	SQL Server T-SQL recipes/ by Jason Brimhall, Jonathan Gennick, Wayne Sheffield.
Author:	Brimhall, Jason.
other author:	Gennick, Jonathan.
Published:	Berkeley, CA :Apress : : 2015.,
Description:	lxxix, 972 p. :ill., digital ; : 24 cm.;
Contained By:	Springer eBooks
Subject:	SQL (Computer program language) -
Online resource:	http://dx.doi.org/10.1007/978-1-4842-0061-2
ISBN:	9781484200612 (electronic bk.)

SQL Server T-SQL recipes
Brimhall, Jason.

SQL Server T-SQL recipes[electronic resource] /by Jason Brimhall, Jonathan Gennick, Wayne Sheffield. - 4th ed. - Berkeley, CA :Apress :2015. - lxxix, 972 p. :ill., digital ;24 cm.

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Lightly updated for SQL Server 2014 Comprehensive: Covers all common T-SQL problem domains.

ISBN: 9781484200612 (electronic bk.)

Standard No.: 10.1007/978-1-4842-0061-2doiSubjects--Uniform Titles:

SQL server.
Subjects--Topical Terms:

561599
SQL (Computer program language)

LC Class. No.: QA76.73.S67

Dewey Class. No.: 005.7585

SQL Server T-SQL recipes
LDR:02275nam a2200325 a 4500 001 837023
003 DE-He213
005 20160216161300.0
006 m d
007 cr nn 008maaau
008 160421s2015 cau s 0 eng d
020 $a 9781484200612 (electronic bk.)
020 $a 9781484200629 (paper)
024 7 $a 10.1007/978-1-4842-0061-2 $2 doi
035 $a 978-1-4842-0061-2
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.73.S67
072 7 $a UN $2 bicssc
072 7 $a UMT $2 bicssc
072 7 $a COM021000 $2 bisacsh
082 0 4 $a 005.7585 $2 23
090 $a QA76.73.S67 $b B857 2015
100 1 $a Brimhall, Jason. $3 1067579
245 1 0 $a SQL Server T-SQL recipes $h [electronic resource] / $c by Jason Brimhall, Jonathan Gennick, Wayne Sheffield.
250 $a 4th ed.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2015.
300 $a lxxix, 972 p. : $b ill., digital ; $c 24 cm.
520 $a SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed. Focused on solutions: Look up what you need to do. Learn how to do it. Do it. Current: Lightly updated for SQL Server 2014 Comprehensive: Covers all common T-SQL problem domains.
630 0 0 $a SQL server. $3 565415
650 0 $a SQL (Computer program language) $3 561599
650 1 4 $a Computer Science. $3 593922
650 2 4 $a Database Management. $3 669820
650 2 4 $a Programming Languages, Compilers, Interpreters. $3 669782
700 1 $a Gennick, Jonathan. $3 1067580
700 1 $a Sheffield, Wayne. $3 1067581
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer eBooks
856 4 0 $u http://dx.doi.org/10.1007/978-1-4842-0061-2
950 $a Professional and Applied Computing (Springer-12059)