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