How to insert keyvalue as a row in table?
<p>I have table variable which contains records in terms of key,value pair of a table. where key is the column of table and value is the value for that column</p>

<p>below is table variable</p>

<pre><code>DECLARE @Table TABLE( 
FieldName varchar(100), 
FieldValue varchar(max))

insert into @Table values('Title','NewFrom')
insert into @Table values('Points','4')
insert into @Table values('createdby','5')
</code></pre>

<p>I have above values in UsersInformation.This is physical table of sql server
has following column.</p>

<pre><code> UserID int autoincrement(identity)
 Title nvarchar(100),
 Points int,
 createdby int
</code></pre>

<p>I want that all values of @Table should be as a single row of UserInformation table.</p>

<p>How can be using sql server?</p>