uniqueidentifier转换成varchar数据类型的sql语句

---涂聚文 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