Re: [NF] Learn about Stored Procedures

ts business. > Until such time as the property in the goods passes to the buyer the seller > shall be entitled at any time > -----Original Message- > From: ProfoxTech On Behalf Of Stephen > Russell > Sent: 28 February 2019 14:45 > To: profoxt...@leafe.com > Subject: [NF] Learn

RE: [NF] Learn about Stored Procedures

ct: [NF] Learn about Stored Procedures Here is a very simplistic tutorial on how to make stored procedures in SQL SERVER. You can apply the same concept to most other RDBMS you want to use. https://www.mssqltips.com/sqlservertutorial/168/different-options-for-creating-sql-server-stored-procedur

Re: [NF] Learn about Stored Procedures

All you need is a case statement to fire the correct code going forward. It really sucks to bring in another back end but the customer must pay for what THEY WANT. You could really consider putting up an AWS cloud environment and getting your data from there. Or Azure. Now you get a little bit

Re: [NF] Learn about Stored Procedures

On 2019-02-28 09:45, Stephen Russell wrote: I have some long stored procedures that are in the 3000 lines long arena Jesus...that makes my head hurt just thinking about that. I get the efficiency angle but I really enjoy breaking work up into much more manageable/readable units in the

Re: [NF] Learn about Stored Procedures

Holy Crap Stephen - that's a DAMN Funny comic! I love it!!! Even my son is familiar with XKCD! To make my reply even MORE Interesting - and a comment I am DAMN SURE that Ed would appreciate - truth is - my son is a bit of a computer expert now, in some way. Since, you see - he's actually a

[NF] Learn about Stored Procedures

Here is a very simplistic tutorial on how to make stored procedures in SQL SERVER. You can apply the same concept to most other RDBMS you want to use. https://www.mssqltips.com/sqlservertutorial/168/different-options-for-creating-sql-server-stored-procedures/ If you do this you can stop writing