sql uniqueidentifier转换成varchar 数据类型

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

---塗聚文 Geovin Du DECLARE @myid uniqueidentifier SET @myid = NEWID() SELECT CONVERT(char(255), @myid) AS 'char'; GO --塗聚文 Geovin Du declare @allstring char(255),@AreaUid Uniqueidentifier set @AreaUid='37A1DA94-4AC6-4ED0-B96F-BA3FE6AEACC8' set @allstring= cast(@AreaUid as char(255)) select @allstring --塗聚文 Geovin Du declare @allstring char(255),@AreaUid Uniqueidentifier,@s varchar(200) set @AreaUid='37A1DA94-4AC6-4ED0-B96F-BA3FE6AEACC8' set @allstring= CONVERT(char(255),@AreaUid) set @s=cast(@allstring as varchar(200)) select @allstring,@s --塗聚文 Geovin Du declare @allstring char(255),@AreaUid Uniqueidentifier,@s varchar(200) set @AreaUid='37A1DA94-4AC6-4ED0-B96F-BA3FE6AEACC8' select @s=CONVERT(varchar(200),cast(@AreaUid as char(225))) select @s