Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. I realized I was going a little nuts when I realized I'd need a stack in T-SQL

I realized I was going a little nuts when I realized I'd need a stack in T-SQL

Scheduled Pinned Locked Moved The Lounge
databasesql-servercomsysadmindata-structures
8 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H Offline
    H Offline
    honey the codewitch
    wrote on last edited by
    #1

    Then I discovered I wasn't entirely alone in this: Implement a stack in SQL Server using stored procedures – SQLServerCentral[^] Although I will be using temporary tables instead of external stored procedures. It's weird enough driving simple finite automata from a database, but driving push-down automata from inside a database is a little insane.

    Real programmers use butterflies

    J P 2 Replies Last reply
    0
    • H honey the codewitch

      Then I discovered I wasn't entirely alone in this: Implement a stack in SQL Server using stored procedures – SQLServerCentral[^] Although I will be using temporary tables instead of external stored procedures. It's weird enough driving simple finite automata from a database, but driving push-down automata from inside a database is a little insane.

      Real programmers use butterflies

      J Offline
      J Offline
      Jorgen Andersson
      wrote on last edited by
      #2

      You're crazy. I love it! :laugh: But yes, a temptable and a row pointer variable is probably the right way to do it. If you really need to. :)

      Wrong is evil and must be defeated. - Jeff Ello

      1 Reply Last reply
      0
      • H honey the codewitch

        Then I discovered I wasn't entirely alone in this: Implement a stack in SQL Server using stored procedures – SQLServerCentral[^] Although I will be using temporary tables instead of external stored procedures. It's weird enough driving simple finite automata from a database, but driving push-down automata from inside a database is a little insane.

        Real programmers use butterflies

        P Offline
        P Offline
        PIEBALDconsult
        wrote on last edited by
        #3

        Use the right tool for the right job. :sigh:

        H 1 Reply Last reply
        0
        • P PIEBALDconsult

          Use the right tool for the right job. :sigh:

          H Offline
          H Offline
          honey the codewitch
          wrote on last edited by
          #4

          That doesn't sound like fun at all. :laugh:

          Real programmers use butterflies

          P 1 Reply Last reply
          0
          • H honey the codewitch

            That doesn't sound like fun at all. :laugh:

            Real programmers use butterflies

            P Offline
            P Offline
            PIEBALDconsult
            wrote on last edited by
            #5

            I have created Turing Machines in T-SQL, but only to prove that it can be done, not for reals.

            H 1 Reply Last reply
            0
            • P PIEBALDconsult

              I have created Turing Machines in T-SQL, but only to prove that it can be done, not for reals.

              H Offline
              H Offline
              honey the codewitch
              wrote on last edited by
              #6

              The primary reason I'm targeting T-SQL with a parser is to ensure that my code generation templates are flexible enough to be able to target most any language.

              Real programmers use butterflies

              pkfoxP 1 Reply Last reply
              0
              • H honey the codewitch

                The primary reason I'm targeting T-SQL with a parser is to ensure that my code generation templates are flexible enough to be able to target most any language.

                Real programmers use butterflies

                pkfoxP Offline
                pkfoxP Offline
                pkfox
                wrote on last edited by
                #7

                Keep at it I'm looking forward to the article.

                "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP

                H 1 Reply Last reply
                0
                • pkfoxP pkfox

                  Keep at it I'm looking forward to the article.

                  "Life should not be a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming “Wow! What a Ride!" - Hunter S Thompson - RIP

                  H Offline
                  H Offline
                  honey the codewitch
                  wrote on last edited by
                  #8

                  Have you seen Reggie lately? I wrote this Dismantling Reggie[^] which covers how Reggie works. The thing is, Norm works the same way, but instead of FA state machines for lexers and matchers, it writes PDA state machines for parsers. It's shockingly similar, so understanding how Reggie works will make understanding Norm par for the course. As far as understanding the process of generating the parse tables that the code is generated from, I've covered that in several previous articles and I won't be covering it that much when I cover Norm, any more than I covered the workings of the regular expression engine when covering Reggie. I'm just putting that out there FWIW, and so you know what to expect.

                  Real programmers use butterflies

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups