ASCII table and UNICODE table
You can easily change the font of "SQL Query Analyzer":
TOOLS/OPTIONS/FONTS
2001-08-22
729 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