ASCII table and UNICODE table
You can easily change the font of "SQL Query Analyzer":
TOOLS/OPTIONS/FONTS
2001-08-22
736 reads
ASCII table and UNICODE table
You can easily change the font of "SQL Query Analyzer":
TOOLS/OPTIONS/FONTS
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE ASCIItable
--usage:
--exec dbo.asciitable
AS
DECLARE @i int,@j int, @c VARCHAR(100)
SET @i=32
WHILE @i<=255
BEGIN
SET @j=0
SET @c=''
WHILE @j<=7
BEGIN
SET @c=@c+right(' '+CONVERT(VARCHAR(3),@i), 3)+' '+ CHAR(@i)+' '
SET @j=@j+1
SET @i=@i+1
END
PRINT @c
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE PROCEDURE UNItable AS
--UNICODE table
declare @i int, @c nchar(1), @line nvarchar(4000)
SET @i=32
SET @line=''
WHILE @i<65536
BEGIN
SET @c=NCHAR(@i)
SET @line=@line+ RIGHT(' '+rtrim(convert(nchar(7),@i)),6)+' '+@c+' '
if ((@i-31) % 12=0)or (@i=65535)
BEGIN
PRINT @line
SET @line=''
END
SET @i=@i+1
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO