Addison Wesley Professional, 2006. — 1088 p. — ISBN10: 0-321-38218-8 ; ISBN13: 978-0-321-38218-4. Hosting the Runtime: SQL Server As a Runtime Host. Procedures and Functions in .NET CLR Languages. In-Process Data Access. User-Defined Types and Aggregates. Security. SQL Engine Enhancements. T-SQL Language Enhancements. XML in the Database: The XML Data Type. XML Query Languages:...
Sams, 2006. — 456 p. — ISBN10: 0-672-32741-4 ; ISBN13: 978-0-672-32741-4. Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the...
Key Book Benefits: -Delivers practical, hands-on guidance on sophisticated uses of T-SQL, including the differences between logical and physical processing, nesting of queries, and much more -Provides deep background information that helps developers optimize queries, aggregate data, and develop hierarchies and recursive queries -Helps promote mastery of T-SQL -Features numerous...
All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise...
Microsoft Press, 2006. — 532 p. — ISBN 978-0735621978. Written by a T-SQL guru, this thorough, hands-on reference for database developers and administrators focuses on language features and how they are interpreted and processed by the SQL Server execution engine. Datatype-Related Problems, XML, and CLR UDTs. Temporary Tables and Table Variables. Cursors. Dynamic SQL. Views....
Комментарии