skip to content
Transact-SQL desk reference Preview this item
ClosePreview this item

Transact-SQL desk reference

Author: Deac Lancaster
Publisher: Upper Saddle River, NJ : Prentice Hall/Professional Technical Reference, ©2004.
Edition/Format:   eBook : Document : EnglishView all editions and formats

Intended for programmers of various levels working with Microsoft SQL Server, this book includes definitions that give the full syntax of each command, along with examples of each command in use.  Read more...


(not yet rated) 0 with reviews - Be the first.

More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...


Genre/Form: Electronic books
Additional Physical Format: Print version:
Lancaster, Deac.
Transact-SQL desk reference.
Upper Saddle River, NJ : Prentice Hall/Professional Technical Reference, ©2004
(DLC) 2003059668
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Deac Lancaster
OCLC Number: 144529940
Reproduction Notes: Electronic reproduction. [S.l.] : HathiTrust Digital Library, 2010. MiAaHDL
Description: 1 online resource (xvii, 806 pages) : illustrations
Details: Master and use copy. Digital master created according to Benchmark for Faithful Digital Reproductions of Monographs and Serials, Version 1. Digital Library Federation, December 2002.
Contents: Preface. Acknowledgment. 1. RDBMS Concepts - A Primer. Database Management System Background. Brief History of Relational DBMSs and SQL Language. SQL Language. Where Does SQL Fit In? Chronology of SQL Standards. SQL Server 2000 Product Line. Client-Server Architecture. Three-Tier Client-Server Architecture. RDBMS: Tables and Databases. Tables in a Database. Databases in Microsoft SQL Server. The SQL Language and MSS's Transact-SQL. Comments. Data Types - First Look. Domain and NULL Values. Metadata and Data. Data Definition Language (DDL) and Data Manipulation Language (DML). DDL Examples-CREATE TABLE, ALTER TABLE, DROP TABLE. DML Examples-INSERT, UPDATE, DELETE, SELECT. Case Sensitivity in SQL Statements. RDBMS Utility to Show Table Structure. Lab Exercises. Lab Exercise 1: Introduction to Using Microsoft SQL Server. Lab Exercise 2: CREATE TABLE. Lab Exercise 3. 2. SQL Building Blocks and Server Settings. SQL Server Instance. The SQL Server Database. Data Representation. General Data Type Information. Domain and NULL Value. Constant (Literal) Defined. Identifiers-Naming SQL Objects. Using Identifiers as Qualified Object Names. Expressions in an SQL Statement. Operators. SQL Server 2K Data Types. Numeric Data Type Overview. String Data Type Overview. Other Data Type Overview. Transact-SQL Data Type Precedence. Transact-SQL Data Type Hierarchy. BIGINT, INT, SMALLINT and TINYINT Details. BIT Data Type Details. DECIMAL and NUMERIC Data Type Details. MONEY and SMALLMONEY Data Type Details. FLOAT and REAL Data Type Details. DATETIME and SMALLDATETIME Data Type Details. CHAR and VARCHAR Data Type Details. NCHAR and NVARCHAR Data Type Details. SYSNAME Data Type Details. TEXT, NTEXT and IMAGE Data Type. BINARY(n) and VARBINARY(n) Data Type Details. CURSOR Data Type Details. SQL_VARIANT Data Type Details. TABLE Data Type Details. TIMESTAMP (ROWVERSION) Data Type Details. UNIQUEIDENTIFIER Data Type Details. User-Defined Data Types. Enterprise Manager-Create and Manage a User-Defined Data Type. Transact-SQL-Create and Manage a User-Defined Data Type. Transact-SQL Functions. Aggregate Functions. Cursor Functions. Configuration Functions. Date and Time Functions. Mathematical Functions. Metadata Functions. Rowset Functions. Security Functions. String Functions - for CHAR or VARCHAR expressions. System Functions. System Statistical Functions. Text and Image Functions and Statements. Deterministic and Nondeterministic Functions. CASE Expression. CAST and CONVERT. System Stored Procedures and DBCC. System Stored Procedures. DBCC. Server, Database and Session Settings. Settings Overview. Database Configuration (Database Properties). Session (Connection) Configuration Settings. Default Nullability of New Columns in a Table. Collation. 3. Data Definition Language and Security. Data Definition Language (DDL). Metadata and Data. Types of Objects Managed by DDL. sp_detach_db and sp_attach_db. CREATE, ALTER, DROP DATABASE. sp_bindefault and sp_unbindefault. CREATE, DROP DEFAULT. CREATE, ALTER, DROP FUNCTION. Query Analyzer Debugger Functions (UDF). CREATE, DROP INDEX. CREATE, ALTER, DROP PROCEDURE. Query Analyzer Stored Procedure DebuggerDebugger. CREATE RULE, DROP RULE, sp_bindrule. CREATE SCHEMA. CREATE, UPDATE, DROP STATISTICS. STATS_DATE. CREATE, ALTER, DROP TABLE. CREATE, ALTER, DROP TRIGGER. CREATE, ALTER, DROP VIEW. Indexed View. PARTITIONED VIEWS. Displaying Metadata. System Stored Procedures to Display Metadata. ANSI Information Schema Views. Metadata Functions. SELECT statements on the system tables. Using Enterprise Manager to Observe Metadata. Security. Client Program Login to SQL Server. SQL Server Authentication Mode Options. Database Level Access. Roles. Creating Logins and Roles. Chapter Lab Exercises. Lab Exercise 1: CREATE TABLE emps3, depts3. 4. Data Manipulation Language-INSERT, UPDATE, DELETE, SELECT. INSERT. INSERT Syntax. INSERT and SELECT with an IDENTITY Column. UPDATE. UPDATE-Basic Syntax. UPDATE-Complete Syntax. DELETE. DELETE Syntax. TRUNCATE TABLE. TRUNCATE TABLE Syntax. SELECT. SELECT Statement Syntax. Column Aliases. SET Operations. SET Operations - UNION, UNION ALL. SET Operations - INTERSECTION. SET Operations - SET DIFFERENCE. Hints-Join Hints, Query Hints and Table Hints. 5. Transaction Control, Backup and Restore and Transact-SQL Programming. Transaction Control-ANSI SQL and MSS. Transaction Concepts. Starting and Ending a Transaction. ISOLATION Is Obtained through Locking. Automatic (Implicit) Transaction Mechanisms. Explicit Transaction Mechanisms. Transaction Control: Isolation Levels. Defining Isolation Levels. Implementation of the Isolation Levels Using Locks (MSS). Setting Isolation Level. Server Shutdown. MSS 2000. MSS 7. @@version. Identifying Version and Service Pack. BACKUP AND RESTORE. File System Backup vs Database Backup. Database Backup. Types of SQL Server Database Backup. Transaction Log Backup (TLBU). MSS 2000 Recovery Models. BACKUP DATABASE, BACKUP LOG. BACKUP DATABASE. BACKUP LOG. Truncate Log-Emptying the Transaction Log. BACKUP-1. Backup Dialog. RESTORE DATABASE. RESTORE LOG. Restore Dialog. RESTORE Command. Restore Using Example Backup Strategy. Comments about Backup and Restore. Database Layout for Performance and Restorability. RAID. Production Database-Suggested Disk Layout 1. Production Database-Suggested Disk Layout 2. Introduction to Transact-SQL Programming. Batches. EXEC[UTE]. Two forms of SQL Comments. PRINT. Variables. Program Flow Control. BEGIN - END. RETURN. IF-ELSE. WHILE, BREAK, CONTINUE. GOTO and Labels. WAITFOR. Example TRANSACT-SQL Stored Procedure. Error Handling. Managing Error Messages. sp_addmessage, sp_altermessage, sp_dropmessage. @@ERROR. RAISERROR. Cursors. SQL-92 Cursor. Transact-SQL Extended Cursor (T-SQL Cursor). Commands Used with Cursors. Cursor Functions and Stored Procedures. Dynamic SQL. Appendix A. Appendix B. Bibliography. Index.
Responsibility: Deac Lancaster.


User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...


Be the first.

Similar Items

Related Subjects:(2)

User lists with this item (1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data

Primary Entity

<> # Transact-SQL desk reference
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
    library:oclcnum "144529940" ;
    library:placeOfPublication <> ; # Upper Saddle River, NJ
    library:placeOfPublication <> ;
    rdfs:comment "Warning: This malformed URI has been treated as a string - ''" ;
    schema:about <> ;
    schema:about <> ; # SQL server.
    schema:about <> ; # SQL server.
    schema:about <> ; # Database management
    schema:bookFormat schema:EBook ;
    schema:copyrightYear "2004" ;
    schema:creator <> ; # Deac Lancaster
    schema:datePublished "2004" ;
    schema:exampleOfWork <> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isSimilarTo <> ;
    schema:name "Transact-SQL desk reference"@en ;
    schema:productID "144529940" ;
    schema:publication <> ;
    schema:publisher <> ; # Prentice Hall/Professional Technical Reference
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url <> ;
    schema:url "" ;
    schema:url <> ;
    wdrs:describedby <> ;

Related Entities

<> # Prentice Hall/Professional Technical Reference
    a bgn:Agent ;
    schema:name "Prentice Hall/Professional Technical Reference" ;

<> # Upper Saddle River, NJ
    a schema:Place ;
    schema:name "Upper Saddle River, NJ" ;

<> # SQL server.
    a schema:CreativeWork ;
    schema:name "SQL server." ;

<> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;

<> # Deac Lancaster
    a schema:Person ;
    schema:familyName "Lancaster" ;
    schema:givenName "Deac" ;
    schema:name "Deac Lancaster" ;

    a schema:CreativeWork ;
    rdfs:label "Transact-SQL desk reference." ;
    schema:description "Print version:" ;
    schema:isSimilarTo <> ; # Transact-SQL desk reference

    rdfs:comment "from Safari" ;
    rdfs:comment "(Unlimited Concurrent Users)" ;

Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.