Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server´s BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you´ll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database´s own execution plans Replace external and manual JSON processes with SQL Server´s internal, JSON functionality Who This Book Is For Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications.
XML Schema:The W3C´s Object-Oriented Descriptions for XML Eric van der Vlist
Über dieses Buch Dieses Kompendium führt Sie in die ABAP-Programmierung unter NetWeaver ein. Basierend auf ABAP Objects, behandelt es umfassend alle Konzepte des modernen ABAP (bis Release 7.0): SAP NetWeaver Application Server ABAP, reguläre Ausdrücke, Shared Objects, klassenbasierte Ausnahmebehandlung, Assertions, Web Dynpro ABAP, Object Services, dynamische Programmierung, Schnittstellen (RFC, ICF, XML) und Testwerkzeuge. Wo unverzichtbar, kommen auch die klassischen Programmiertechniken zur Sprache. Aus dem Inhalt: Grundlagen der Unternehmensplanung und -steuerung SAP NetWeaver Application Server ABAP ABAP Workbench, Object Navigator, Class Builder etc. Grundlegende Sprachelemente von ABAP Objects Klassische Modularisierung und Programmausführung Fehlervermeidung und Fehlerbehandlung GUI-Programmierung: Dynpros, Listen, Controls u.v.m. Persistente Daten: DB-Zugriffe, Object Services etc. Feldsymbole, RTTS, dynamische Token-Angabe und Prozeduraufruf Schnittstellen: RFC, ICF,Webservices, XML
Why spend time on coding problems that others have already solved when you could be making real progress on your Ruby project? This updated cookbook provides more than 350 recipes for solving common problems, on topics ranging from basic data structures, classes, and objects, to web development, distributed programming, and multithreading. Revised for Ruby 2.1, each recipe includes a discussion on why and how the solution works. You?ll find recipes suitable for all skill levels, from Ruby newbies to experts who need an occasional reference. With Ruby Cookbook, you?ll not only save time, but keep your brain percolating with new ideas as well. Recipes cover: * Data structures including strings, numbers, date and time, arrays, hashes, files and directories * Using Ruby?s code blocks, also known as closures * OOP features such as classes, methods, objects, and modules * XML and HTML, databases and persistence, and graphics and other formats * Web development with Rails and Sinatra * Internet services, web services, and distributed programming * Software testing, debugging, packaging, and distributing * Multitasking, multithreading, and extending Ruby with other languages
Get Started on Microsoft SQL Server 2008 in No Time Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner´s Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered. Set up, configure, and maintain SQL Server 2008 Build and manage database objects using Transact-SQL statements Create stored procedures and user-defined functions Optimize database performance, availability, and reliability Implement solid security using authentication, encryption, and authorization Automate tasks using SQL Server Agent Create reliable data backups and perform flawless system restores Use all-new SQL Server 2008 Business Intelligence, development, and administration tools Learn in detail the SQL Server XML technology (SQLXML)
ActionScript 3.0, the latest version of the Flash Platform´s scripting language, offers many new and powerful features. ActionScript is now a full-fledged programming language, with complete object-oriented capabilities, improved event handling, sound and video support, drawing capabilities, support for regular expressions, and much more. Whether you are a Flash designer wishing to add to your skill set or an experienced ActionScript developer who wants to get up to speed with the latest version, you´ll find all you need to know in Foundation ActionScript 3.0 for Flash and Flex. Starting with the fundamentals, you´ll learn how to add interactivity to your Flash movies by using ActionScript objects, manipulating sound and video, and harnessing the power of regular expressions and XML. The book concludes with two case studies to consolidate what you´ve learned and introduce some additional advanced techniques. You´ll gain a solid understanding of the new and exciting world of ActionScript 3.0 and see how everything fits together to form complete applications, so you´ll be able to build your own professional sites. The sensible layout of the book makes it easy to find information about specific techniques. It focuses on the essential skills that will enable you to get up and running quick. With this book as your guide, you´ll be creating killer Flash applications before you know it.