Select from following answers:- Use CASE
- Use CHAR
- Use TEXTPTR
- Use COS
- All Above
Check the below script to add carriage return or new line feed to the text in SQL server...
--Observe the output
PRINT 'Hello' + 'Chandrika'
PRINT 'Hello' + CHAR(10) + 'Chandrika'
Explanation: With the help of CAHR function we can do
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator