shohelr2003 (1/14/2013)

---

Dear,
I want to insert multiple lines in a single row in SQL Server 2008 R2. I have tried. But it's not working. A table has only one column and it contains information like following.

Name: XYZ
Cell:1325646
Blood: B+

How is it possible? Please help me.

create table #MultiRow
(
	SomeValue varchar(1000)
)

insert #MultiRow 
select 'Name: XYZ
Cell:1325646
Blood: B+'

select * from #MultiRow

drop table #MultiRow

shohelr2003 (1/15/2013)

---

Thank you, Sir. Your code works.

Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I use char(13) + char(10), it will work too, won't it?

Another query is when sms will be sent, do the format remain same or will be changed?

Actually I wanna convey SMS from my database through mobile operator. That's why I want to insert data in my convenient format. If I use char(13) + char(10), it will work too, won't it?

Another query is when sms will be sent, do the format remain same or will be changed?

shohelr2003 (1/15/2013)

---

@Bhuvnesh,
Actually it is a distributed query. I wrote an AFTER TRIGGER that will fetch information from six tables that will be SMS content and insert into a remote database's VIEW. In addition to, I formatted the SMS body as business requirements from the database information.

shohelr2003 (1/16/2013)

---

If I execute an insert query into linked server, it works. But when I use trigger to execute an insert query into linked server, it fails and generates the following error message.

"The operation could not be performed because OLE DB provider "SQLNCLI10" for linked server "Server2" was unable to begin a distributed transaction."