SQL Server: Insert Result of WHOAMI into Table
<p>I have a table with 2 columns, one of which I would like to insert the result of the <code>WHOAMI</code> command. Tried doing the following but I presume it won't work due to the different amount of columns:</p>

<pre><code>UPDATE tblName 
SET colName = (xp_cmdshell 'whoami.exe') 
WHERE id = 1
</code></pre>