Creating Multiplication Table in SQL SERVER
I have attended an interview 2 days ago; In that interview I got a question in which I have to create a Multiplication Table for a particular Number in PL/SQL... So Here I am with a Multiplication table of 8..
You can Modify the same for other integers..
You can Modify the same for other integers..
DECLARE @i INT SET @i = 0; -- Alternate syntax to club above two lines DECLARE @j INT SET @j= 8; -- Multiplicaiton table for 8. Change this. PRINT 'Multipliction table for ' + CONVERT(VARCHAR, @j) + ':' + CHAR(13); -- newline WHILE (@i < 10) -- show 1 to 10 BEGIN SET @i = @i + 1; -- Can be written as SET @i += 1; PRINT CONVERT(VARCHAR, @i) + ' x 8 = ' + CONVERT(VARCHAR, @i*@j); END
No comments:
Post a Comment
Thank You for Your Comments. We will get back to you soon.