Basics

Retrieving Data as XML from SQL Server

  • Article

All the hype that once surrounded XML is finally starting to die down, and developers are really beginning to harness the power and flexibility of the language. XML is a data descriptive language that uses a set of user-defined tags to describe data in a hierarchically-structured format.

2007-02-23

3,672 reads

Some Usages for XML

  • Article

While SQL Server 2005 has greatly expanded the XML capabilities of the platform, many DBAs are still not familiar with or comfortable
with using XML in their coding. Yousef Ekhtiari brings us a new article that looks at a basic use of XML in inserting data into a table.

5 (2)

2007-02-22

7,218 reads

Techniques for Uniquely Identifying Database Records

  • Article

When designing and creating a data model for a data-driven application, the records in tables must each be uniquely identifiable. By having a unique value associated with each record, individual records can be selected, updated, or deleted. Being able to uniquely identify records is so important and standard in a database system that databases allow those designing a database table to specify what column (or columns) make up the primary key.

2006-12-22

3,518 reads

Blogs

SQLSaturday Automatic Messages

By

For those who haven’t used the admin tools for SQLSaturday when an event is...

Using the Announcement/News Part of SQLSaturday

By

One of the interesting but not often used features of the SQLSaturday tools is...

SQLSaturday Orlando 2019 Begins

By

We’ll be event number 911, set for September 28th at our usual location at...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Transaction was deadlocked on lock | communication buffer resources with another

By sridharkannan7

I have a table that contains case numbers. The following stored procedure assigns a...

Microsoft and Oracle Cloud Partnership

By Kathi Kellenberger

Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers