|
|
-
|
|
These days, I am spending some time with Service Broker, testing various features exposed by SB. Many times, I am finding errors (due to my bad code) which results in dialog-conversations that are not closed, messages that are not processed etc. So, before testing something new, I needed a way to do......
|
|
-
|
|
In the previous post we have had a short discussion on using the Large Value Types. We have discussed a few points that might help while taking the decision to "go or not to go" with a Large Value type.
The question I am trying to answer in this post is: "Yes, I have given a good thought and decid......
|
|
-
|
|
If you are a programmer working with SQL Server, you must have found it little embarrassing to display information which spans across multiple pages (web pages). SQL Server 2000 did not allow you to retrieve a specific range of records, say, records 51 to 100 ordered by a certain column.
For exa......
|
|
-
|
|
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 ......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
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 am just back from Chennai, after doing a Hands-On-Lab on Microsoft Business Intelligence Platform. It was a great experience spending two days with a wonderful set of SQL Server developers and administrators from Chennai, sharing my experience in building BI solutions using Microsoft Business In......
|
|
-
|
|
I shared my PASS 2009 experience in the previous post. One topic that I did not mention in the previous post, and wanted to write separately is about the PASS Outstanding Volunteer Award. Outstanding Volunteers As many of you know, PASS is run by volunteers all over the world. These volunteers spe......
|
|