Hi Experts;

Good Thanks for all support

ChrisM : we don't have using any control to design this table.

Thanks

FAJ

Thanks for you replay , I am using the error_handling function and Begin Transaction

Error_Number, Error_Message, Error_Severity, Error_State, Error_Line,

Error_Procedure

I want to get the Error_columnname AND Error_value...

Hi;

Thanks for replay , but I want only column name come in Upper not for the entire result sent.

Hence I using the upper function all entire data come in upper...

Hi ;

Nice post , I later to see the post and any way good work.

Thanks;

Faijurrahuman.A

Hi;

Here i use the DelimitedSplit8K Function and splitting the string.

DECLARE @Tmp TABLE(TID INT,ITEM VARCHAR(MAX))

DECLARE @STR VARCHAR(MAX)

SET @STR='COL1=VAL1,COL2=VAL2,COL3=VAL3,COL4=VAL4,COL5=VAL5'

INSERT INTO @Tmp

select * from dbo.DelimitedSplit8K(@STR,'=')

SELECT...

HI

Thanks for response

Here my column names are dynamically passed

Example

create proc test(@table_name varchar(max),@value varchar(max)

as

SET @sql='UPDATE '+@table_name+' SET '+@value +' WHERE CD='+convert(VARCHAR(50),@cd)

EXEC SP_EXECUTESQL @sql

Column names...

Hi;

could you please tell me another method T-SQL

Using T-SQL to solve this problem.

Dear All;

Thanks for all your valuable information ...

I am using Temp Table to sole my problems.

Thanks

Faijurrahuman.A

Hi ;

in SQL Server 2005.

Thank you ver much for your response

Thank you so much

Hi Diva;

Thanks for u r response ;

With regards;

A.Faijurrahuman

Programmer

Coimbatore

Hi;

It's is scalar function It's return only one row

Hai;

To Round the Number Like that 4.6 then '7' (or) 4.4 then '4'

Thanks for your quick response

But in case I have to solve the problem in Trigger ;

How can i Write the script;

Thanks &Advance;

A.Faijurrahuman17