Tag Archives: sql server

Selecting all unique rows from duplicate rows in table in SQL Server

Hi, This post will show how you can write a select query to select only unique rows from a table that has many duplicate rows. In other words, this post will show the query to select distinct rows from a … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , , , | Leave a comment

[Error-Resolved]Could not find the database engine startup handle – SQL Server 2008 R2 installation

Hi, This post describes how to resolve the error that one might encounter while installing SQL Server 2008 R2 from an ISO. I had the setup for SQL Server 2008 R2 in an ISO file. I assumed that extracting the … Continue reading

Posted in .NET, General, SQL Server | Tagged , , , , , , , , , , , , , , | Leave a comment

Retrieving column values as a comma separated string in SQLServer

Hi, This post is quite the opposite of the previous post. That is, in the previous post, We inserted a comma separated string into separate rows. Here we will return a single comma separated string by concatenating values from separate rows.   … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | Leave a comment

Adding items in comma-separated string into separate rows in SQLServer

Hi, In this post, I’ll show how to insert a items in a comma-separated string into separate rows in a table. Consider for example we have a comma-separated string such as “amogh, anish, anvesh, uday”. after inserting into the table, … Continue reading

Posted in CodeProject, General, SQL Server | Tagged , , , , | 1 Comment