Recent PostsToday I am showing you a quick and easy way to concatenate rows of textual data in a single string. This is particularly useful when you need a comma separated list of items, products etc. and you don’t want to loop the whole dataset for performance reasons.
Following is the sample code to demonstrate this. Concept [...]
Displaying a progress bar for each row in a report or displaying a traffic light type status indicator for each row in SQL Server Reporting Services (SSRS) is not possible directly because SSRS just provide you a set of very basic report items like Line, Image etc.
But since Microsoft always design products with extensibility in [...]
Hi Guys,
Although changing the UserName in ASP.NET 2.0 Membership provider is not recommended and Microsoft has made it read only but sometime it becomes necessary to change the incorrect or misspelled login name or user name. To solve this issue, I have created the following stored procedure which can easily change the old Login [...]
Since SQL Server 2005 Management Studio lacks the Object Search feature, here is the simple query to find any column in a database
Select O.name objectName, C.name ColumnName from sys.columns C inner join sys.objects O ON C.object_id=O.object_idwhere C.name like ‘%ColumntoFind%’order by O.name,C.name
This query works for SQL Server 20005. Just replace “ColumnToFind” with your required column name.
