Developer Rants

The bug is that the session will only remember the first item copied to the clipboard.
The previous solution was to log off and on again - which is not appropriate for nested virtual machines.

This solution consists of killing and restarting rdpclip.exe.
I am tempted to create a utility that does just that.

declare @text varchar(1000)
set @text = ‘<a firstname=”Joe” surname=”Blogs” >42</a>’
DECLARE @idoc int
select @text

declare @name varchar(10)
declare @name2 varchar(10)

– Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @text
– Execute a SELECT statement using OPENXML rowset provider.
SELECT @name=surname, @name2 = [firstname]
FROM OPENXML (@idoc, ‘/a’,1)
      WITH ([firstname]  varchar(10),
            surname varchar(20))

select @name, @name2

SELECT age=[text]
FROM OPENXML (@idoc, ‘/a/text()’,2)

EXEC sp_xml_removedocument @idoc