|
|
-
|
|
When you create/alter a stored procedure, SQL Server will perform a certain set of validations and will throw an error if the validation fails. After a stored procedure is created, you might make changes to the underlying objects that could break the stored procedure. The script presented in this po......
|
|
-
|
|
We saw a number of string manipulation examples using FOR XML and XML Data Type methods. Here is yet another string parsing requirement that we will solve using the XML Data type methods. In this post, we will see how to extract words from strings stored in a column, that match with a given patte......
|
|
-
|
|
I heard this question a few times recently. Most database products support Auto-number columns that generate a unique number, every time a row is inserted. In SQL Server, they are called IDENTITY columns. While creating a table, you can specify a certain column as an IDENTITY column. The following ......
|
|
-
|
|
I found this question in the MSDN SQL Server XML forum and wrote a query to help the user who posted it. I wanted to write a query using XQuery but could not write it instantly. There does not seem to be an easy way to get the full path of an element or attribute. One option I can think of, is writi......
|
|
-
|
|
All the examples we saw in the previous posts loaded information into a single table. There are times when you might need to load data into multiple tables. Some times these tables may be related and some times they may not be. In this post, we will see an example that shows how to load data from an......
|
|
-
|
|
I wrote a couple of posts that show how to do string parsing using XML, some time back. Those posts explained how to retrieve a result set from a delimited string using the XML approach. You can find those articles in the links given below.
http://beyondrelational.com/blogs/jacob/archive/2008/08/14......
|
|
-
|
|
One of the questions I used to ask while interviewing developers for my company, is about optimizing queries. Most of the times I hear people say that the first thing to do is to add enough indexes so that the joins and filters will execute faster. Seldom I hear about execution plans and the need to......
|
|
-
|
|
One of my readers recently contacted me with an XML shaping requirement. He wanted to generate an XML document with a specific structure from a result set that he has created. Here is the source data. RootNode ParentNode Node Name Number Valid Value--------------- ---------- ----- -----......
|
|
-
|
|
Continued from FOR XML EXPLICIT Tutorial – Part 3 This is a late addition to the 3 part FOR XML TUTORIAL I wrote last year. You can find Part 1 here, Part 2 here and Part 3 here. When generating the XML document, FOR XML EXPLICIT processes rows in the same order as they are returned by the query.......
|
|
-
|
|
SQL Server Management Studio is equipped with a large number of features that many people admire. Most of the work I do is around SSMS and there are a few features that I use frequently. One of those features that I use is the 'Registered Servers' window.
I find the 'Registered Servers' window ver......
|
|