GURUS GUIDE TO TRANSACT SQL (CD INCLUDED)

SINCE ITS INTRODUCTION OVER A DECADE AGO, THE MICROSOFT SQL SERVER QUERY LANGUAGE, TRANSACT-SQL, HAS BECOME INCREASINGLY POPULAR AND MORE POWERFUL. THE CURRENT VERSION SPORTS SUCH ADVANCED FEATURES AS OLE AUTOMATION SUPPORT, CROSS-PLATFORM QUERYING FACILITIES, AND FULL-TEXT SEARCH MANAGEMENT. THIS BOOK IS THE CONSUMMATE GUIDE TO MICROSOFT TRANSACT-SQL. FROM DATA TYPE NUANCES TO COMPLEX STATISTICAL COMPUTATIONS TO THE BEVY OF UNDOCUMENTED FEATURES IN THE LANGUAGE, THE GURU'S GUIDE TO TRANSACT-SQL IMPARTS THE KNOWLEDGE YOU NEED TO BECOME A VIRTUOSO OF THE LANGUAGE AS QUICKLY AS POSSIBLE. IN THIS BOOK, YOU WILL FIND THE INFORMATION, EXPLANATIONS, AND ADVICE YOU NEED TO MASTER TRANSACT-SQL AND DEVELOP THE BEST POSSIBLE TRANSACT-SQL CODE. SOME 600 CODE EXAMPLES NOT ONLY ILLUSTRATE IMPORTANT CONCEPTS AND BEST PRACTICES, BUT ALSO PROVIDE WORKING TRANSACT-SQL CODE THAT CAN BE INCORPORATED INTO YOUR OWN REAL-WORLD DBMS APPLICATIONS. YOUR JOURNEY BEGINS WITH AN INTRODUCTION EXPLAINING LANGUAGE F