All Type Coding

Search Here

How to print 0 to 9 ASCII value in sql server .?


Declare @num int,@temp varchar(50)
set @num=0
while(@num<=9)
begin
set @temp=(select ASCII(cast(@num as varchar)))
print'The ASCII Value of '
+cast(@num as varchar)+' = '+@temp
set @num=@num+1
end


No comments :

Post a Comment