Drop Procedure sp_conv_getcolproperty
Go
Create Procedure sp_conv_getcolproperty(@table_name             nvarchar(384),
                                 @column_name           nvarchar(384),
                                 @property              nvarchar(384),                           
                                 @outvals     nvarchar(384) OUTPUT)


As
/* 
**********************************************************
Procedure       : sp_conv_getcolproperty.sql
Author          : Sundar Murugappan
Created         : Oct-14-2005
Modified        : Oct-14-2005
Version : 1.0
**********************************************************
*/


DECLARE @SQLSTR1         NVARCHAR(384)
Declare @OutputParameter varchar(100) 
SET QUOTED_IDENTIFIER OFF


SET @SQLSTR1 = "Select  @val1 = "+ @property + "  from syscolumns "
SET @SQLSTR1 = @SQLSTR1 + " where name = ''" + @column_name +  "'' and id = (select id from sysobjects where name =  ''" + @table_name + "'')"
exec sp_executesql @SQLSTR1,N''@val1 NVARCHAR(100) OUT'',@OutputParameter out
select @outvals = @OutputParameter
return @OutputParameter
SET QUOTED_IDENTIFIER ON