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
I enjoy what you guys are usually up too. This sort of clever work and coverage! Keep up the wonderful works guys I’ve added you guys to my blog roll.
ReplyDeleteDotnet developer dotnet training in bangalore