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

Learning Postgres:Installation

By

I had the opportunity of working on a project converting a postgres database to...

Transforming JSON data with the help of Azure Data Factory - Part 3

By

(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform)...

Disks performance in Azure

By

In our earliest post, we have discussed in detail about the factors that affect...

Read the latest Blogs

Forums

fetcth aggregate data

By aabasoj

Hi All,   I am having table where below list of columns OrderNo ActualHours...

Who is the best person for the job?

By bkubicek

Comments posted to this topic are about the item Who is the best person...

Create Custom Functions in Power Query

By Archana

Comments posted to this topic are about the item Create Custom Functions in Power...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Linux Support

See possible answers