Click here to Skip to main content
15,898,035 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have created one stored procedure which sends html format. here, inside the html tag, i have selected column from database.

for example table name : tbspmail and column name infocom . everything works fine except alignment to this td.
if you look in database it is inserted correcly like below.
**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.
**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON (TEST TEST GOOD)
EMPLOYEE SIGNATURE: X__________________________________

when i do select query inside html

N''+
N'

'+
cast((SELECT ISNULL(infocom,'')FROM tbspmail FOR XML PATH(''),TYPE) AS NVARCHAR(MAX)) +'

'+

I am getting like below,

**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN
AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON
(TEST TEST GOOD) EMPLOYEE SIGNATURE: X__________________________________


i have table width 780.

so, how can i get output with correct alignment like below:

**NO VALUE FOR GOOD KNOWLEDGE IN GOVT FIELD BUT IT IS VALUE FOR IT FIELD.

**GOOD** ALL VALUES & TEST GOOD, NO PAIN NO GAIN AS WELL AS IT IS EQUAL TO THIS MEANING LIKE NO BRAIN
NO GAIN ALL IS WELL MR.BILLGATES IS LOVELY PERSON (TEST TEST GOOD)

EMPLOYEE SIGNATURE: X__________________________________
Posted

1 solution

SQL
DECLARE @email NVARCHAR(500)
SET @email = 'Email line 1.' + CHAR(13) + 'Email line 2.'
PRINT @email
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900