Browse by Tags

All Tags » TSQL (RSS)

Storing/Retrieving Hierarchies In SQL Server Database by aghausman12

Hierarchies are one of the most important part of many applications. It can be in shape of categories, family tree, organization charts etc. Maintaining hierarchies in data source like XML is not a big deal but when it comes to the database like SQL Server...
Filed under: ,

Get Column name From Stored Procedure by aghausman12

The requirement of the day is to extract the name of the columns returned by procedures. Stored Procedures are dynamic that is why we need to create a function that takes Stored Procedure name as parameter and return the column names in string. So here...
Filed under: , ,

Configure SQL Server 2008 for File Stream by aghausman12

Well, from past two days I am working on SQL Server 2008 new feature called File Stream. In the period of SQL Server 2005 when we want to store some files to the database we can have that using varbinary(max) but that approach is not either smart nor...
Filed under: ,

CLR Integration and Lightweight Pooling Conflict by aghausman12

I thought I am CLR Integration Guru in Sql Server but this morning I came to know that there are lots of things left to grab. While I was moving the local database on the new live server I run some CLR Procedure which Says these procedures required CLR...
Filed under: ,
More Posts