ASCII table and UNICODE table
You can easily change the font of "SQL Query Analyzer":
TOOLS/OPTIONS/FONTS
2001-08-22
714 reads
Joseph Gama,
2002-12-11
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
You rated this post out of 5. Change rating
2001-08-22
714 reads
2001-08-22
366 reads
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
652 reads
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
399 reads
2001-08-22
699 reads