|
|
-
|
|
You might get the following error while working with HIERARCHYID data types in RC0:Could not find method 'IsDescendant' for type 'Microsoft.SqlServer.Types.SqlHierarchyId' in assembly 'Microsoft.SqlServer.Types'The IsDescendant() method of HIERARCHYID d...
|
|
-
|
|
In the previous post, we have examined the new HIERARCHYID data type introduced by SQL Server 2008. HIERARCHYID is a CLR data type and it supports a number of methods. Note that the methods of CLR data types are case sensitive. Most of us, who do not bo...
|
|
-
|
|
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......
|
|
-
|
|
This is a question that I often hear from people around. Let us have a closer look into the various factors that help us to answer this question.
One of the feeling that I see, many people have is "Hey, there is VARCHAR(MAX), just use it, and you don't need to worry if the future requirements to in......
|
|
-
|
|
This is a question that I often hear from people around. Let us have a closer look into the various factors that help us to answer this question.
One of the feeling that I see, many people have is "Hey, there is VARCHAR(MAX), just use it, and you don't need to worry if the future requirements to in......
|
|
-
|
|
One of the points raised in the recent UG meeting was the question about HAVING and WHERE. So the question is, Which is better? HAVING or WHERE? Which one should I use?
The question "which one should I use" is bit confusing because each operator has a different job to do. WHERE filters rows and HAV......
|
|
-
|
|
HIERARCHYID is a new data type introduced in SQL Server 2008. I had worked on a few assignments where I had to deal with hierarchical data. I guess most of you have at least once worked with a hierarchical data model. Traversing a hierarchy is not very ...
|
|
-
|
|
Jamie Thomson has written a blog post showing problems of NOT using aliases and explains the advantages of using aliases. you can find the post here. I agree with Jamie and would like to invite all TSQL programmers to use table aliases always.
Jamie has mentioned that the absence of aliases will ma......
|
|
-
|
|
This may be a very simple example. I don't know if this specific example would help anyone. However, the approach may give some of you a hint that can solve another problem that you may be trying to solve. In fact, the purpose of this whole series is to show some examples that might help some one so......
|
|
-
|
|
I came across a post in the MSDN SQL Server XML forum asking for some sample code that reads information from the XML instance and inserts it into two tables. At first glance, the request looked simple. But then I realized, that while inserting the information to the tables, I need to establish a re......
|
|