Аннотация

Create and modify databases and keep them secure Get up to speed on using T-SQL to store and manipulate data SQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more. * Create queries to retrieve data * Ensure SQL Server security * Use Visual Studio(r) 2005 with SQL Server * Create tables, views, and indexes * Work with Common Language Runtime * Query XML data

Аннотация

Replacing DTDs (Document Type Definitions) as the way in which XML documents are described and validated, XML schemas are essential for ensuring the accuracy and security of information in B2B transactions and other XML applications. This how-to guide employs extensive examples and source code to help developers and programmers get quickly up to speed on the practical application of this important technology. With in-depth explanations for each example, XML expert Mike Fitzgerald acquaints readers with coding structures, then moves to more advanced topics, including unique element and attribute values, keys, and how to use schemas with HTML. Like the other books in the series, this guide features comprehensive appendices listing all the datatypes and data facets, code indexes, and other time-saving features.