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,221 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

Arrays in PowerShell–#SQLNewBlogger

By

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

Passwords = A Good Thing

By

Those my friends are, in my opinion, one of the single most wonderful things...

Speaking at SQL Saturday Oregon

By

SQL Saturday Oregon — in the city of Portland — is taking place next...

Read the latest Blogs

Forums

Get lat/long from Point

By HildaJ

Hello everyone, I have a table with a field "shape" which is geometry.  I...

help !split the rows!

By caojunhe24

hi there, am new to SQL and now am trying to do row split....

split one rows to multiple rows in the table based on the size

By caojunhe24

hi there, am new to SQL and now am trying to do row split....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers