|
|
|
|
|
Total Hits: 275 | Today: 0 |
Author: Alex Homer
|
Rating:
|
|
|
Ever since the mid 90’s, as XML has evolved to become the optimum way to share, transport and persist data, developers have sought efficient ways to store, manipulate and generally take advantage of its capabilities. Increasingly fast and easy-to-use XML parsers have been developed, transport protocols such as SOAP have been used to implement Web Services around XML, and many applications, tools and programming libraries now include features to import and export their data as XML....
|
|
|
|
Total Hits: 139 | Today: 0 |
Author: Alex Homer
|
Rating:
|
|
|
This is the third and final article in a series of three that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and query XML documents that are stored within the database. SQL Server 2005 provides native support for XML that can vastly improve application performance, while supporting robust and safe multi-user access to the data...
|
|
|
|
Total Hits: 372 | Today: 1 |
Author: ABitSmart
|
Rating:
|
|
|
SQL XML enables you to convert the from a stored procedure/user defined function into XML format. Using this functionality, you can work with stored procedures or functions without needing to know the table column information being returned....
|
|
|
|
Total Hits: 250 | Today: 0 |
Author: Shawn Wildermuth
|
Rating:
|
|
|
As database developers, many of us have had to dip our feet into the wide ocean of XML.
It should come as good news that in SQL Server 2005, you can store XML in the database with a new XML datatype. Although this is good news, many developers have been storing XML in the database for some time now. Even without implicit support for XML, developers have been shoving XML documents into text fields since XML's inception...
|
|
|
|
Total Hits: 354 | Today: 0 |
Author: Jimmy Nilsson
|
Rating:
|
|
|
Not all of the XML support in SQL Server 2000 is useful in real world applications in my opinion. I'm thinking of the possibility to send queries to SQL Server by HTTP and receive the answer as XML documents. The security problems with that seem to be huge in the current version. (For example, your database schema will be more or less public to your users and they can easily learn to do similar things directly with your database, as you are doing with your "behind-the-scenes" HTTP calls.)...
|
|
|
|
Total Hits: 753 | Today: 0 |
|
Rating:
|
|
|
Covering the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets....
|
|
|
|
Total Hits: 488 | Today: 0 |
Author: Jimmy Nilsson
|
Rating:
|
|
|
Designing your stored procedures return and accept XML is a really useful thing to do! We'll cover some of the XML SQL Server 2000 features and discuss using them in your stored procedures. Jimmy Nilsson is the owner of the Swedish consultant company JNSK AB...
|
|
|
|
Total Hits: 1282 | Today: 0 |
Author: Shivani
|
Rating:
|
|
|
This sample shows how you can obtain a Dataset from (in this case) a SQL Server database, and then write it out to an XML Document. As an "Extra Added Bonus(tm)", it can show you how to write the schema as well. The SQL Server database in question is the venerable and useful Northwind database....
|
|
|
|
Total Hits: 346 | Today: 0 |
Author: Rob Vieira
|
Rating:
|
|
|
XML has taken the industry by storm - not only revolutionizing the way that web pages are generated, but also the way that data is exchanged between disparate systems. This session will explain the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-based queries, XML views/schemas, and how the addition of XSLT transformations can greatly simplify the delivery of XML data to disparate targets...
|
|
|
|
Total Hits: 598 | Today: 0 |
Author: Jeffrey Juday
|
Rating:
|
|
|
Often in software development, a new tool introduces old, reliable, battle-tested techniques to an equally reliable and mature platform. SQL Server 2005 Service Broker is such a technology. Service Broker brings the world of asynchronous messaging to the SQL Server database platform....
|
|
|
|
Total Hits: 412 | Today: 0 |
Author: Deepak Vohra
|
Rating:
|
|
|
you can think of an XML document as a relational table where the various elements represent columns in a database table. Therefore, by mapping the various elements to a table, you can store XML in relational databases. This mapping process is called XML-to-SQL mapping technology....
|
|
|
|
Total Hits: 1198 | Today: 0 |
|
Rating:
|
|
|
With SQL Server 2000, there are many ways you can get XML representation of relational data. The options include using FOR XML clause with SELECT statement, ADO Recordset's Save method with adPersistXML parameter, etc. It would be nice to have a reverse mechanism, which allows turning XML document into tabular, relational rowset format. The good news is that SQL Server 2000 team thought about this and introduced a new Transact-SQL keyword named OPENXML along with two new supporting system...
|
|
|
|
Total Hits: 83 | Today: 0 |
Author: Alex Homer
|
Rating:
|
|
|
This is the second in a series of three articles that look at how the latest version of Microsoft’s enterprise-level database, SQL Server 2005, now offers great support and close integration with XML as a data persistence format. This includes new ways to validate, store and query XML documents that are stored within the database. SQL Server 2005 provides native support for XML that can vastly improve application performance, while supporting robust and safe multi-user access to the data contain...
|
|
|
|
|
|
|
