25%
Microsoft SQL Server 2000 Programming by Example

Microsoft SQL Server 2000 Programming by Example

4       |  3 Reviews 
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

Table of Contents:
Introduction. 1. Relational Database Management Systems and SQL Server. Database Models. A Brief History of SQL Server. Basics of SQL Server Architecture. Client/Server Applications Design. 2. Elements of Transact-SQL. Data Definition Language (DDL). Data Manipulation Language (DML). Data Control Language (DCL). Data Types. Additional Elements. Programming Scripts and Batches. 3. Working with Tables and Views. Creating and Altering Tables. Creating and Altering Views. 4. Querying and Modifying Data. Querying Data. Modifying Data. 5. Querying Multiple Tables: JOINs. ANSI SQL-92 Syntax. INNER JOIN. OUTER JOINs. CROSS JOINs. Self Joins. The UNION Operator. 6. Optimizing Access to Data: Indexes. Introduction to Indexes. Benefits of Indexes. How to Create Indexes. How SQL Server 2000 Stores Data. How SQL Server 2000 Modifies Data. Index Enhancements in SQL Server 2000. Accessing Data Without Indexes: Table Scan. Types of Indexes. Covered Queries and Index Intersection. Index Maintenance. Indexes on Computed Columns. Indexed Views. Index Tuning Wizard. Summary. 7. Enforcing Data Integrity. Types of Data Integrity. Enforcing Integrity: Constraints (Declarative Data Integrity). 8. Implementing Business Logic: Programming Stored Procedures. Benefits of Using Stored Procedures. Types of Stored Procedures. Creating and Dropping Stored Procedures. Using Parameters. Altering Stored Procedure Definitions. The RETURN Statement. Executing Stored Procedures. Stored Procedure Recompilation. Handling Errors. Nesting Stored Procedures. Application Security Using Stored Procedures. 9. Implementing Complex Processing Logic: Programming Triggers. Benefits of Triggers. Trigger Enhancements in SQL Server 2000. Inserted and Deleted Tables. Types of Triggers According to Their Order. Creating and Dropping Triggers. Altering Trigger Definitions. Disabling Triggers. Nesting Triggers. Recursive Triggers. Security Implications of Using Triggers. Enforcing Business Rules: Choosing Among INSTEAD OF Triggers,. Constraints, and AFTER Triggers. 10. Enhancing Business Logic: User-Defined Functions (UDF) Benefits of User-Defined Functions. Built-In User-Defined Functions. Types of User-Defined Functions According to Their Return Value. Dropping User-Defined Functions. Preventing the Alteration of Dependent Objects: The SCHEMABINDING Option. Deterministic and Nondeterministic Functions. Altering User-Defined Functions Definition. Security Implications of Using User-Defined Functions. Applying User-Defined Functions. 11. Using Complex Queries and Statements. Subqueries. Correlated Subqueries. Derived Tables. The CASE Function. The COMPUTE Clause. The CUBE and ROLLUP Operators. Using Hints. 12. Row-Oriented Processing: Using Cursors. Row-by-Row Versus Set-Oriented Processing. Types of Cursors. Steps to Use Cursors. Scope of Cursors. Using Cursors to Solve Multirow Actions in Triggers. Application Cursors. 13. Maintaining Data Consistency: Transactions and Locks. Characteristics of Transactions (ACID). Using Transactions. Concurrency Problems. Isolation Levels. Types of Locks. A Serious Problem to Avoid: Deadlocks. 14. Transferring Data to and from SQL Server. The Need for Transferring Data. Tools for Transferring Data Using SQL Server 2000. The BULK INSERT Statement and bcp. Using Data Transformation Services. The Copy Database Wizard. 15. Working with Heterogeneous Environments: Setting Up Linked Servers. Distributed Queries. Distributed Transactions. Appendix A. Using SQL Server Instances. Installing SQL Server Instances. Connecting to Instances. System Functions Used in Multi-Instance Installations. Current Limitations. Appendix B. Using SQL Query Analyzer. Installing SQL Query Analyzer. The Query Analyzer Workplace. Managing User and Connection Options. Defining and Using Templates for Query Analyzer. Analyzing Queries. Working with the Transact-SQL Debugger. Summary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780789724496
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Height: 229 mm
  • No of Pages: 792
  • Series Title: By Example
  • Weight: 1336 gr
  • ISBN-10: 0789724499
  • Publisher Date: 26 Apr 2001
  • Binding: SA
  • Language: English
  • Returnable: Y
  • Spine Width: 47 mm
  • Width: 188 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

4       |  3 Reviews 
out of (%) reviewers recommend this product
Top Reviews
Rating Snapshot
Select a row below to filter reviews.
5
4
3
2
1
Average Customer Ratings
4       |  3 Reviews 
00 of 0 Reviews
Sort by :
Active Filters

00 of 0 Reviews
SEARCH RESULTS
1–2 of 2 Reviews
    BoxerLover2 - 5 Days ago
    A Thrilling But Totally Believable Murder Mystery

    Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!

    BoxerLover2 - 5 Days ago
    A Thrilling But Totally Believable Murder Mystery

    Read this in one evening. I had planned to do other things with my day, but it was impossible to put down. Every time I tried, I was drawn back to it in less than 5 minutes. I sobbed my eyes out the entire last 100 pages. Highly recommend!


Sample text
Photo of
    Media Viewer

    Sample text
    Reviews
    Reader Type:
    BoxerLover2
    00 of 0 review

    Your review was submitted!
    Microsoft SQL Server 2000 Programming by Example
    Pearson Education (US) -
    Microsoft SQL Server 2000 Programming by Example
    Writing guidlines
    We want to publish your review, so please:
    • keep your review on the product. Review's that defame author's character will be rejected.
    • Keep your review focused on the product.
    • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
    • Refrain from mentioning competitors or the specific price you paid for the product.
    • Do not include any personally identifiable information, such as full names.

    Microsoft SQL Server 2000 Programming by Example

    Required fields are marked with *

    Review Title*
    Review
      Add Photo Add up to 6 photos
      Would you recommend this product to a friend?
      Tag this Book
      Read more
      Does your review contain spoilers?
      What type of reader best describes you?
      I agree to the terms & conditions
      You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

      CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

      These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


      By submitting any content to Bookswagon, you guarantee that:
      • You are the sole author and owner of the intellectual property rights in the content;
      • All "moral rights" that you may have in such content have been voluntarily waived by you;
      • All content that you post is accurate;
      • You are at least 13 years old;
      • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
      You further agree that you may not submit any content:
      • That is known by you to be false, inaccurate or misleading;
      • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
      • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
      • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
      • For which you were compensated or granted any consideration by any unapproved third party;
      • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
      • That contains any computer viruses, worms or other potentially damaging computer programs or files.
      You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


      For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


      All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

      Accept

      New Arrivals


      Inspired by your browsing history


      Your review has been submitted!

      You've already reviewed this product!
      ASK VIDYA