Basics

Using XQuery to Manage XML with SQL Server 2005

  • Article

XML is now becoming more widely used as wireless devices are becoming more secure, and new technologies such as XQuery for SQL Server 2005 are making it much easier to handle XML more efficiently at the server level. Jesse Smith gives you a crash course on XQuery methods and how you can use them in certain situations to retrieve and update XML data stored in your SQL Server 2005 database.

2006-05-18

3,096 reads

Using XQuery, New Large DataTypes, and More

  • Article

SQL Server 2005 introduces a lot of new features, but it also enhances the popular and oft-used Transact-SQL (T-SQL) language. Changes include the introduction of new datatypes to store large values using the MAX indicator, the integration of enhanced XML querying and data modification with XQuery, and the new XML datatype.

2006-05-08

2,508 reads

Database Design and Reference Tables

  • Article

Whether you are building SQL Server 2000 applications or getting ready for the new features in SQL Server 2005, there are many fundamental database design principals that should be followed. New author Ranga Narasimhan brings us a look at how he handles reference tables when designing a database..

2.5 (10)

2005-09-27

19,850 reads

Introduction to XQuery in SQL Server 2005

  • Article

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features. Non-supported features of XQuery in SQL Server 2005 and workarounds are described in this article. It also presents three scenarios where XQuery is useful.

2005-06-23

2,686 reads

XML Simplified

  • Article

Everyone should be aware that XML is supported in SQL Server 2000 and plays an integral part of not only SQL Server 2005, but all of the Windows family. IIS metadata, web services, etc. all involve XML. But do you know what XML is and how to work with it? Author Raj Vasant brings us a basic article on what XML is and how the documents are structured.

2005-05-23

13,055 reads

Blogs

Who needs data access? Not You!

By

With a little planning and care, we can find various ways to fulfill user...

Azure Synapse Analytics & Power BI performance

By

With two new relational database features (Result-set caching and Materialized Views) just GA’d in...

Session Evaluations from “SQL Server Security from the Ground Up”

By

I was recently given the opportunity to speak at Pass Summit. As always (this...

Read the latest Blogs

Forums

Merge statement not working as expected for bulk load.

By Arjun

Hi, Am using merge sp to insert or update records  in target table.Below is...

Any redundancy on SSIS Worker Server

By samalex

I'm loving the idea of the SSIS Scale Out option in SQL 2017 and...

Reset Sequences

By nrdroque

hi, what are the best procedure to automate the  reset of a sequence every ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers