473,785 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Advanced Transact-SQL Reference book - Need recommendations !

I currently have two SQL server books for MS SQL Server 2000. One is a
prep book for the 70-229 exam, the other is a Wrox book: "profession al
SQL Server 2000 Programming."

I'm looking for more T-SQL books that give me PRACTICAL tips on
writing advanced queries. What book do you refer to? Please post them.
Jul 20 '05 #1
3 2216

"ChrisL" <ch***********@ gmail.com> wrote in message
news:9e******** *************** ***@posting.goo gle.com...
I currently have two SQL server books for MS SQL Server 2000. One is a
prep book for the 70-229 exam, the other is a Wrox book: "profession al
SQL Server 2000 Programming."

I'm looking for more T-SQL books that give me PRACTICAL tips on
writing advanced queries. What book do you refer to? Please post them.


"Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is very
good, as are Joe Celko's books. Also see here:

http://vyaskn.tripod.com/sqlbooks.htm

Simon
Jul 20 '05 #2
Simon Hayes wrote:
"Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is
very good


The Amazon reviews rip this book to shreds.

--
Steve Troxell
Jul 20 '05 #3
Hi

The reviews seem very polar, I guess you just love it or hate it!!
Michael Hotek probably sums the book up best in his review.

John


"Steve Troxell" <st***********@ nospam.hotmail. com> wrote in message
news:mA******** **********@torn ado.tampabay.rr .com...
Simon Hayes wrote:
"Advanced Transact-SQL for SQL Server 2000" by Ben-Gan and Moreau is
very good


The Amazon reviews rip this book to shreds.

--
Steve Troxell

Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
2795
by: Millissa | last post by:
If someone can help me with examples of or info on how to create an advanced tables for the layout on my site, I would be very grateful! Thanks, M
3
2046
by: hrishy | last post by:
Hi Does anybody have the steps to install db2v8.1 on redhat advanced server 3.0.THe db2 i have is form the linux starter kit available freely on developerworks for learning purpose. I tried on redhat 7.3 however it fails whil creating the instance saying the db2iupdt tool is not of the right version. regards
4
5140
by: Nhmiller | last post by:
This is directly from Access' Help: "About designing a query When you open a query in Design view, or open a form, report, or datasheet and show the Advanced Filter/Sort window (Advanced Filter/Sort window: A window in which you can create a filter from scratch. You enter criteria expressions in the filter design grid to restrict the records in the open form or datasheet to a subset of records that meet the criteria.), you see the design...
3
1302
by: Luis Esteban Valencia | last post by:
Hello. I wish to buy some advanced .net or c# books.. I am interested in design patterns, windows services and more advanced topics. Thanks
68
2664
by: pemo | last post by:
What would expect to be covered? Say you'd already attended a course, that had covered stuff like structs, pointers, bitwise and logical operators, multi-demensional arrays , *but* hadn't covered other stuff like recursion, unions, bit-fields . What topics would /should be covered on a course that takes students further?
4
11577
by: Gaijinco | last post by:
I read somewhere that printf and scanf had "advanced features" and they point to: scanf("%",line); // line is a string as an example, where scanf() acts like gets() I try to look of more of this "advanced features" in documentation but couldn't found any. What "advance features" do you of these functions (printf and scanf)?
0
1859
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I am running Access 2007. I have a report that I want to filter. I can go into Advanced...Advanced Filter/Sort... and setup a filter that works fine on the report when I apply it. When in this query creation area, I can right click and Save Query. I have saved a query fine. However, now if I go back later (after closing Access or the report) when I open it it back up (the report), I go back to Advanced...Advanced Filter/Sort.. right click...
0
2222
by: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+ | last post by:
I am running Access 2007. I have a report that I want to filter. I can go into Advanced...Advanced Filter/Sort... and setup a filter that works fine on the report when I apply it. When in this filter/query creation area, I can right click and Save Query. I have saved a query fine. However, now when I open the report back up (after closing Access or the report) and go back to Advanced...Advanced Filter/Sort.. right click and 'Load from...
3
1751
by: Scott Bradley | last post by:
Hi All, We are using SQL2000 servers with transact replication to a warm stand-by server. We are seeing the following error from the Log reader agents. Does anyone have any insight on this error? The process could not execute 'sp_MSadd_repl_commands27hp' TIA Scott B.
11
5152
by: sunnyalways4u2000 | last post by:
hello sir, Sir will please tell me the exact difference between C and advanced C...what are the extra features or funcions...etc added in this advanced one.
0
9484
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10350
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8983
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7505
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6742
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5386
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4055
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3658
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2887
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.