That differences I knew, I am asking what is the differecne between Unicode & ASCII text file in SQL Server, both are generating .sql file and content also same. What...

I read in some blog that Stored procedure execute faster than trigger. And I am trying to call stored procedure inside the trigger to perform some action instead of writing...

I got an answer after researching.

It was problem with \t,,\r

It used this statement to remove blank spaces.

LTRIM(RTRIM(REPLACE(REPLACE(REPLACE(CompanyInfo, CHAR(13), ''), CHAR(10), ''), CHAR(9), '')))

do you know any specific user defined function for zip/unzip?

For example I get credit report as xml file and its around 6MB size. I can store it in database. Event I can zip (compress) and store it in Database...

My doubt how to Convert Byte Array to string

I can not pass directly Byte Array to database.

because input to database is string (i.e., nvarchar(max)).

This is fine.

But How can I store this compressed data in Database. Database column either ntext or nvarchar(max).

Doubt is now How to store byte array in Database?