DECLARE @position int, @nstring nchar(12)
SET @position = 1
SET @nstring = N'字符串' PRINT 'Character #' + ' ' +
'Unicode Character' + ' ' + 'UNICODE Value' WHILE @position <= DATALENGTH(@nstring)
BEGIN
SELECT @position, CONVERT(char(17), SUBSTRING(@nstring, @position, 1)),
UNICODE(SUBSTRING(@nstring, @position, 1))
SELECT @position = @position + 1 END
转载于:https://www.cnblogs.com/maoyu417/archive/2008/05/29/1210191.html