Recently working in Microsoft SQL Server I needed to find all the dependencires for a specific stored procedure. I ended up with the following:
WHERE ROUTINE_DEFINITION LIKE'%myStoredProcedure%'
This query looks through all the stored procedure definitions, in the MY_DB database, for the words myStoredProcedure. The results will display all the stored procedures including the myStoredProcedure.
I’m fairly new to .NET and I’m finding it a challenge locating solutions for some problems I was having. I decided to start writing down the solutions I found or created. There might be better ways to solve the problems. If you find a better way please let me know.
Now on the problem. To start off the application is written in VB.NET 2.0. There is a form with a asp dropdown control that I needed to set the datasource. This dropdown control lives inside a asp repeater control. I wanted to set the datasource inside an expression like the following:
xml-stream emits events while parsing and sequelize uses promises during it’s querying. Having that work together and be readable/maintainable was a challenge.
A previous post, Nginx and Node.js with Docker, I created a Node.js Docker container that copied source files inside a Docker image. It’s a challenge to change any of the files in the Node.js Docker container since it’s baked into the Docker image. A different approach would be to mount a host folder in the Docker container. This way I can edit/add/delete files which would be reflected in the Docker container. The idea is to create a bare Node.js server that I can conintue to develop.