Basics

Technical Article

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

SQLServerCentral Article

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,321 reads

Technical Article

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

Creating a new User-Defined Data Type–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

A new chapter begins

By

In 2012 when I originally founded Born SQL, I never imagined I would find...

Daily Coping 19 Jan 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Recursive Triggers

By Ken at work

I know there is, somewhere, T-SQL that will allow me to update (keep in...

How to get cummulative sum per column?

By Barendrecht82

Hi, I have a statement per period. I want the periods to be cumulate. ...

Secondary Filegroup

By jayoub

Hi, I have a quick question If I have a database with a primary...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers