guid和字符串的转换

1.生成新的Guid:

 Guid.NewGuid();

2.把一个转换成字符串的guid再转换成Guid:

Guid gid=new Guid(str); 

3.另外一个关于guid的问题

UPDATE Stock
SET EndAmt = 40
WHERE ([GUID] =
          (SELECT TOP 1 [GUID]
         FROM Stock b
         WHERE (ProductID = '01333')))
用以上的语句是得不到结果的,必须加上any

UPDATE Stock
SET EndAmt = 40
WHERE ([GUID] =any
          (SELECT TOP 1 [GUID]
         FROM Stock b
         WHERE (ProductID = '01333')))