STUFF function in SQL

  Recently in one of our assignment we have utilized STUFF function of SQL Server 2005. So just want to share the same. Stuff is very simple function to delete specified length of symbols and insert new symbols in string. We can say it’s a next version for REPLACE function. Following is simple test environment for STUFF function Above SQL script is simple to understand; so use this in your...

Xml Basics in SQL Server 2005

Xml Basics – SQL Server 2005 Hello All, We have used some basic features for Xml structure in SQL Server 2005 in one of our assignment; just want to share the same. When we heard Xml phenomena in context of SQL Server 2005; it creates lot of curiosity about motivation after using the same. In this article we will concentrate on some Xml standard methods which are part of SQL Server 2005, and...

SQL Error: Database diagram support objects cannot be installed

Solution to MS SQL Error: Database diagram support objects cannot be installed If you ever get a message like this when trying to create a diagram in SQL 2005 “Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database...