I have a business process that requires someone to manually copy/paste calls to stored procedures into SQL Management studio… Most of these stored procedures dont even have parameters or result sets. So my question is, can we call these procedures from a page in SP without having to build something in Visual Studo? I picture something like a button (or even hyperlink) that a non-tech user can just click on. This would clean up and simplify this process massively.
Of course, also getting rows from procedure results back into SP would be ideal. Then I could set up some simple reporting (using existing stored procedures) for user feedback. So they know when to click the next button or whatnot 😉
Any ideas dear SP community?
(Visited 639 times, 1 visits today)
- Make a custom Webpart you can add all your logic inside it click button save button etc run sql query your templates etc
- https://blogs.msdn.microsoft.com/sharepointdev/2011/02/10/a-step-by-step-guide-in-designing-bcs-entities-by-using-a-sql-stored-procedure-jyoti-saikia/#_Toc279612938 bcs
(Visited 1 times, 1 visits today)
