Advanced Transact-SQL for SQL Server 2000 by Itzik Ben-Gan

Posted by

By Itzik Ben-Gan

In Advanced Transact-SQL for SQL Server 2000, authors Itzik Ben-Gan and Thomas Moreau discover the robust functions of Transact-SQL (T-SQL). Ben-Gan and Moreau supply recommendations to universal difficulties encountered utilizing all models of SQL Server, with a spotlight at the most up-to-date model, SQL Server 2000.

Expert advice and actual code examples train complicated database programmers to write down extra effective and better-performing code that takes complete benefit of T-SQL. The authors provide sensible ideas to the typical difficulties programmers face and contain in-depth info on complex T-SQL subject matters akin to joins, subqueries, saved tactics, triggers, user-defined features (UDFs), listed perspectives, cascading activities, federated perspectives, hierarchical constructions, cursors, and more.

Show description

Read Online or Download Advanced Transact-SQL for SQL Server 2000 PDF

Similar sql books

Murach's SQL Server 2008 for Developers (Murach: Training & Reference)

This e-book is designed to educate software builders the entire talents they should use SQL to paintings with a Microsoft SQL Server 2008 database. yet it's additionally an exceptional first booklet for builders who're at the route to turning into a DBA.
Unlike so much SQL Server 2008 books, this one begins by way of displaying you ways to exploit SQL queries to extract and replace the knowledge in a database, simply because that's what each program developer must be aware of first. Then, it indicates the best way to layout and enforce a database, how one can use robust backend database good points like perspectives, saved approaches, features, triggers, cursors, transactions, locking, protection, and the way to paintings with BLOB and XML info. ultimately, it exhibits how one can use the CLR integration characteristic to create database gadgets utilizing a . internet language equivalent to C# or visible Basic.
<h4>From the publisher</h4>
The SQL booklet that the majority builders don't even understand they want that's how i feel of this book.
To be a good program developer, you must grasp SQL for the database you re going to be utilizing. yet many builders get through with the SQL they recognize, by no means understanding how a lot they're lacking out on.
So this can be to begin with a booklet for builders who use Microsoft SQL Server as their DBMS (though it will possibly assist you to be able to grasp regular SQL, too). regardless of how a lot SQL event you've got, you'll locate new positive aspects that you simply haven't been taking virtue of.
In part 1, you ll research the recommendations and phrases you wish for operating with any database. You ll additionally how to use the Microsoft SQL Server 2008 administration Studio to paintings with queries and databases. At that time, you ll be ready for quick growth as you examine SQL.
In part 2, you ll study all of the talents for retrieving information from a database and for including, updating, merging, and deleting that facts. those talents flow from the easy to the advanced so that you received t have any difficulty in the event you re a SQL amateur. they usually current abilities like utilizing outer joins, precis queries, and subqueries that would elevate your SQL services should you do have SQL experience.
In part three, you ll layout a database and the way to enforce that layout utilizing both SQL DDL (Data Definition Language) statements or the administration Studio. for those who re performed, you ll have the capacity to layout and enforce your individual databases. yet whether you re by no means referred to as upon to do this, this part provide you with standpoint that may make you a greater SQL developer.
Section four offers the talents for operating with database good points like perspectives, saved tactics, services, triggers, cursors, transactions, and safeguard. It teaches you ways to take advantage of SQL positive factors to paintings with XML information. And it exhibits you ways to exploit the 2008 FILESTREAM garage function to paintings with binary huge items (BLOBs) akin to picture, sound, and video documents. those are the good points that supply a DBMS a lot of its energy and that offer you an additional area on your SQL skills.
To whole your SQL Server talents, part five indicates you the way to take advantage of the CLR integration function. this option helps you to create database gadgets like saved strategies and user-defined kinds utilizing a . web language like C# or visible uncomplicated.

SQL Server Developer's Guide to OLAP with Analysis Services

The talents you want to improve OLAP strategies with SQL Server 2000 This exceptional booklet teaches you every little thing you must understand to exploit Microsoft's research providers software program to construct, enforce, and deal with powerful OLAP recommendations. specialist recommendation and in-depth causes mix that will help you and your organization take complete good thing about the cheap energy of SQL Server's integrated OLAP performance.

Sams Teach Yourself SQL in 21 Days (4th Edition)

Sams educate your self SQL in 21 Days, Fourth variation presents a offered starting place in realizing the basics of SQL (Structured question Language). SQL is the question language utilized by relational databases the sort of Oracle, Microsoft entry, and Microsoft SQL Server. the recent variation covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, gaining access to distant databases, and constructs.

Professional SQL Server 2008 Internals and Troubleshooting

A hands-on source for SQL Server 2008 troubleshooting tools and instruments SQL Server directors have to make sure that SQL Server continues to be operating 24/7. Authored via prime SQL Server specialists and MVPs, this e-book presents in-depth assurance of top practices in keeping with a deep knowing of the internals of either SQL Server and the home windows working approach.

Additional resources for Advanced Transact-SQL for SQL Server 2000

Sample text

25 Advantage 8 Cross joins in the SQL−92 syntax should explicitly include the CROSS JOIN keywords, whereas in the old−style syntax, a cross join looks like an inner join where the join condition is simply not specified. This makes the old−style syntax prone to errors, because a programmer might forget to mention a join condition and instead of getting an error, get a cross join. This can be a really sneaky problem if you are joining two tables on two columns and specify only one column by mistake.

An illegal attempt is shown in Listing 1−21. jobid This query will produce an error, indicating that the query contains an outer join request that is not permitted. If you want to supply employee, department, and job information for matching employees and departments, preserving all jobs, you can write the query in Listing 1−22 using the SQL−92 syntax. jobid The output of this query is shown in Table 1−12. 00 NULL deptno 100 200 400 400 400 NULL deptname Engineering Production Management Management Management NULL jobid 10 20 30 30 30 40 jobdesc Engineer Worker Manager Manager Manager Cleaner But you're out of luck again with the old−style syntax shown in Listing 1−23.

This is the part of the syntax that might look a bit strange at the beginning. The first FROM clause is optional, and you might prefer not to use it if you find the query less confusing without it. Also, the Order Details table appears twice. The first occurrence (after the first FROM clause) specifies which table is modified, and the second occurrence (after the second FROM clause) is used for the join operation. This syntax doesn't allow you to specify more than one table after the first FROM clause.

Download PDF sample

Rated 4.62 of 5 – based on 40 votes