|
|
-
|
|
Introduction The previous articles were focusing on TYPED XML and had been explaining how to generate an XML schema that can be used to validate the XML data. We have seen how to validate the existence of elements and attributes, how to validate data types and how to apply restrictions on the actua......
|
|
-
|
|
Introduction In the previous article we have seen how to work with TYPED XML and XML SCHEMAs. By using a TYPED XML which is bound to an XML SCHEMA, you can make sure that the value being stored to your XML column or variable is EXACTLY as per the format that you want them to be. SQL Server will per......
|
|
-
|
|
I have written over a dozen articles covering almost all aspects of SQL Server IDENTITY columns. The intention of this page is to serve as an index, so that people can find the right post based on the specific piece of information they are looking for.
How do I create an Auto-number column in S......
|
|
-
|
|
This is my 14th article on SQL Server IDENTITY values. In each post we discussed a couple of interesting points related to the IDENTITY columns. I saw a number of IDENITY related questions in various online SQL Server forums and saw a lot of cases where IDENTITY columns were completely misunderstood......
|
|
-
|
|
Every time some one asked this question in the past, I used to suggest that formatting should be done at the presentation layer. While some of you might agree with me on this, I just wanted to point out that you can do comma formatting of numeric values in TSQL.
You can convert MONEY values (va......
|
|
-
|
|
In XQuery Lab 18, we saw how to delete an element from an XML variable or column. Let us now see, how to delete more than one element from an XML column or variable.
Here is the sample XML that we will examine in this lab.
Employees><br /> Employee><br /> ......
|
|
-
|
|
In the previous posts we have examined IDENTITY columns in detail. We discussed several IDENTITY related functions, commands, system variables and terms. This post intends to summarize them.
IDENTITY Property
IDENTITY is an attribute that you can assign to an integer column in SQL Server. It......
|
|
-
|
|
I was not very fortunate with my blogging platforms since the last few years. I started with blogger in 2006 and then thought it is a better idea to host blogs on my own web site. I used to blog about some SQL Server stuff and some .NET stuff those days. I registered the domain http://www.dotnetques......
|
|
-
|
|
After inserting a row to a table with an IDENTITY column, you can query the global variable @@identity or call SCOPE_IDENTITY() function to retrieve the newly inserted IDENTITY value. In a previous post we saw that @@identity returns the last IDENTITY value generated in the current session, and not ......
|
|
-
|
|
I heard this question from many people. Executing a dynamic OPENXML() query is little tricky.
Before we look at a dynamic OPENXML() query, let us look at the static version. Here is an example document that we will parse using OPENXML() in this session.
Employees><br /> Employee <span st......
|
|