Multiplication Table in SQL Server
This query gives the multiplication table from 1 to 10.
DECLARE @A INT,
@B INT,
@C INT,
@D VARCHAR(100)
SELECT @A=1
PRINT ' MULTIPLICATION TABLE 1-10'
/****************************************/
/* Created By : Loganathan V */
/* Created On: 20-Sep-2010, Monday */
/* Purpose : Multiplication Table */
/* How to : RUN THE QUERY */
/****************************************/
WHILE(@A<=10)
BEGIN
SELECT @B=1
SELECT @D=''
WHILE(@B<=10)
BEGIN
SELECT @C=1
SELECT @C=@A*@B
SELECT @D=+@D+CAST(@C AS VARCHAR)+' '
SELECT @B=@B+1
END
PRINT @D+CHAR(9)
SELECT @A=@A+1
END
The output of this query will be like this.
MULTIPLICATION TABLE 1-10
1 2 3 4 5 6 7 8 9 10
2 4 6 8 10 12 14 16 18 20
3 6 9 12 15 18 21 24 27 30
4 8 12 16 20 24 28 32 36 40
5 10 15 20 25 30 35 40 45 50
6 12 18 24 30 36 42 48 54 60
7 14 21 28 35 42 49 56 63 70
8 16 24 32 40 48 56 64 72 80
9 18 27 36 45 54 63 72 81 90
10 20 30 40 50 60 70 80 90 100
ENJOY QUERYING................
can it be done only by query
ReplyDeleteIn SQL Server you can do it by query only. Why doubt on this? SQL Server is a query language tool. I think you've confused between .Net coding and SQL Server. Yes, of course we can do it by C# coding as well.
Deletecan you pls make it for multiplication tables till 20 i wanna learn them (but this helped me lot )
ReplyDeleteJust change the While condition's limit to 20. That's it.
DeleteDECLARE @A INT,
@B INT,
@C INT,
@D VARCHAR(100)
SELECT @A=1
PRINT ' MULTIPLICATION TABLE 1-20'
WHILE(@A<=20)
BEGIN
SELECT @B=1
SELECT @D=''
WHILE(@B<=20)
BEGIN
SELECT @C=1
SELECT @C=@A*@B
SELECT @D=+@D+CAST(@C AS VARCHAR)+' '
SELECT @B=@B+1
END
PRINT @D+CHAR(9)
SELECT @A=@A+1
END