Skip to main content

Multiplication Table in SQL Server

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................
Labels:

Comments

  1. prithviJuly 30, 2013 at 3:42 AM

    can it be done only by query

    ReplyDelete
    Replies
    1. LoganathanDecember 9, 2013 at 6:16 PM

      In 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.

      Delete
  2. AnonymousOctober 3, 2013 at 5:23 AM

    can you pls make it for multiplication tables till 20 i wanna learn them (but this helped me lot )

    ReplyDelete
    Replies
    1. LoganathanDecember 9, 2013 at 6:13 PM

      Just change the While condition's limit to 20. That's it.

      DECLARE @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

      Delete
  3. shri yadavApril 28, 2018 at 2:51 AM

    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.
    Dotnet developer dotnet training in bangalore

    ReplyDelete

Post a Comment

Popular posts from this blog

Javascript - Unanswered questions - Part 1

What is Event delegation? Event delegation is Javascript as it relates to the DOM. It basically means that if you attach an event listener to a DOM element that listener is not only firing on that DOM element. It's actually firing on every children in that. So, for instance if you have a navigation and so you've got an unordered list you've got list items and then you've got anchor tags inside that navigation what you have. If you add an event listener to the ul element in essence you're actually adding event listener to all of the children as well. In short, JS event listeners fir not only on a single DOM element but on all its descendants. What is Event Bubbling? It's actually inverse of Event delegation. Also known as propagation, events on an DOM element will bubble up and also fire on all parents.  What's the difference between "target" and "currentTarget"? target is the actual element that triggered the event for example clicked, wh...
Post a Comment
Read more

Microservices vs. APIs

It still surprises me just how many times I come across misconceptions around Micro Services and APIs. Often hearing phrases like micro services are fine grained web services or API is themselves are equivalent to micro services. These all sort of show fundamental misconceptions under the covers. So, I've written this just to really break that out and explain about what the key differences are in those two concepts. What is an API? An API, fundamentally Application Programming Interface, that is an interface. It's a way of making requests into a component. So it's the route that you go in to make those requests. In modern use that typically means a REST API, that's a call made using HTTP protocol using JSON data as the payload. What are Micro Services? So let's ensure we also have a clear crisp definition on what a micro service architecture really is. Micro-Services architecture is about breaking down large silo applications into smalle...
Post a Comment
Read more

Large Volume of Dataset Transfer from WCF to Silverlight

Most of the times the developers, architects have the problem to retrieve large volume of data from WCF Service to Silverlight client applications. It’s a big head ache for developers. But it’s not up to that much problematic one. We can solve this problem by changing some property’s values in Web.config of WCF Service host, Silverlight application’s ServiceReference.clientconfig and Silverlight XAP hosted ASP.Net Applications. Here I’m going to explain the Web.config changes we need to retrieve large volume of data from WCF Service and also uploading large size of files to the Server. Last week, I was trying to figure out why my WCF service call always threw the generic NotFound exception when trying to retrieve large datasets. Even though, I set buffer limits to 2147483647 (int.MaxValue) in the Silverlight ServiceReferences.ClientConfig file and WCF Service configuration Section under web.config the problem was persisting. I tried so many things from Data Access Layer and UI. Finall...
5 comments
Read more