Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Programming ISBN: 0-7645-8434-0
This is the forum to discuss the Wrox book Professional SQL Server 2005 Programming by Robert Vieira; ISBN: 9780764584343
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Programming ISBN: 0-7645-8434-0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old November 22nd, 2006, 04:50 PM
Registered User
Join Date: Nov 2006
Location: Bangkok, , Thailand.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default The book content

Is the book content overlapped to "Beginning SQL Server 2005 Programming" ? I browsed the table of content and feel like it is.

Reply With Quote
  #2 (permalink)  
Old November 27th, 2006, 09:27 PM
Registered User
Join Date: Nov 2006
Location: , , USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

The answer to that, quite simply, is "yes". Overlapped is exactly what it is by design.

It was a difficult decision to make, so I attempted to address each audience. For the beginner, it has much of the older beginning level content as it was. The professional title is not really a replacement for the beginning title for someone that is a beginner for one simple reason: Completeness of discussion. While some of the actual prose is shared, you will find that the professional title is more targeted toward a "fill in the blanks" sort of model. It's meant to be a review instead of a introduction. All the "beginning" topics are, by and large, still there primarily for reference, however, things move along faster and entire areas of discussion are downright skipped. Likewise, the intermediate to advanced user can't really just get by on the beginning title as the depth that more advanced topics are addressed is considerably different. Some topics that are in the pro title are not in the beginning title at all. Even in the shared topics, you might find things like internal index layout being discussed in the pro title, but not in the beginning title.

The short rendition is that there is perhaps as much as 30% overlap between the titles, but, at the same time, they are seeking a different depth and each contains discussion that the other does not have. They are most definitely not the same book. If you're an intermediate to advanced SQL Server person, you would want to go straight to the pro title. The "new to SQL Server" person will want the depth of introduction found only in the beginning title, and that book should serve them will for the vast majority of their needs for the first 6 months to a year of working with SQL Server.

I hope that addresses the issue for you!

Reply With Quote
  #3 (permalink)  
Old December 2nd, 2006, 04:22 PM
Registered User
Join Date: Dec 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts


I have requested instructor copies of both your beginning and professional books. I'm an independent instructor who currently teaches for three different schools. I have been asked to prepare for a T-SQL class after the first of the year, and I'm unsure which of the books will be the most appropriate.

Since I found your book on SQL Server 2000 several years back it has always been my best resource on T-SQL.

I have been teaching a generic relational database course (from my own materials) which introduces both PL/SQL and T-SQL. The trigger structure is, of course, quite different. But in PL/SQL we are able to override and change values from INSERT and DELETE statements before the DML operation completes. For example, I teach students to force gender values ('m' & 'f') to upper case ('M', & 'F') before the lower case values can be rejected by a check constraint. This is done in PL/SQL, as you may know, by changing :NEW.gender in the trigger.

In PL/SQL we evaluate new/changed data by querying the INSERTED table. When I first learned this (from your book) I experimented with updating the INSERTED table. Occasionally the change would be carried to the final row image, but not often. I could find nothing in your book about changing values on-the-fly in a trigger. More than one of the MS SQL Server "gurus" I've met has said "oh, yeah... there's a way to do that". But none have ever gotten back to me with a solution. You are the foremost expert on SQL Server that I know of (because you can write a book on the subject that people can actually understand). Can you tell me if this is possible, and if so how it is done?


Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
After completing this book. Then which book shoul? zhshqzyc ASP.NET 2.0 Basics 4 January 28th, 2009 06:20 AM
finding free book "Beginning Jsp Book" ruzdi JSP Basics 0 December 7th, 2007 12:46 PM
Choosing content depending on content of other ele dsekar_nat XSLT 1 February 27th, 2006 04:58 AM
Help,I can't find my book in your book list. 5uer All Other Wrox Books 2 August 21st, 2004 12:43 AM

All times are GMT -4. The time now is 02:28 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.