3
Stored procedure, enableecord and alternatives?
source link: https://www.codesd.com/item/stored-procedure-enableecord-and-alternatives.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Stored procedure, enableecord and alternatives?
advertisements
In a PowerBuilder-based project, there are overs three hundred stored procedures on a Microsoft SQL Server. It's a client-server application which relies a lot on PB's DataWindow.
Now, there is an feature request from the users which will most likely add several web-based screens to interface with the system.
We are evaluating Rails (for our team member experience) and CakePHP (for performance/deployment considerations).
We use a lot of ActiveRecord (on Rails, naturally) for other web-based projects. However, stored procedures and ActiveRecord do not play well with each other.
I'd like to hear your experience and suggestions on:
- how to minimize rewriting (duplicating) the stored proecedures in ActiveRecord
- besides what we are already looking at (Rails and CakePHP), what are the alternatives (say, DataWindow.NET?, LINQ?)
Thanks!
Powerbuilder 11.5 Webform's datawindows work very nicely with stored procedures. It works exactly the same as client-server Powerbuilder. No rewrite at all.
Related Articles
Can anyone explain the advantages and disadvantages of stored procedures and Java stored procedures pros and con?
Can anyone say Stored procedures pros and cons AND Java Stored Procedures pros and con? And how to test it. Best regards!The arguments for and against stored procedures tend to split on what you think is the correct answer to the question: does busin
How to insert values into the table from stored procedure entries and the temporary table
I have a stored procedure like this: create procedure spname @ID varchar, @name varchar, @R xml AS BEGIN -- Getting values XML create table #Table ( country varchar, status varchar ) I have to insert the values into a table based on the condition tha
Stored Procedure Parameters and Crystal Reports
I am creating a Stored Procedure that will be used as the Data Source for a Crystal Report. The Stored Proc takes two input parameters - int and a comma delimited string list Create procedure sp_AP_YTD_Payments1 @Year as int, @Companies nvarchar(MAX)
Stored procedure, transactionScope, and SQL Server stored
I have to update some DataTable for which I am sending the data as XML. My stored procedure has transaction to abort the operation if something goes wrong. But the number of records I have to update is quite large and the XML reaches to 35 mb+. It is
Stored Procedures - Updated and Inserted
I'm new to using stored procedures, what is the best way to update and insert using stored procedures. I have two tables and I can match them by a distinct ID, I want to update if the ID exists in both my load table and my destination table, and I wa
Call to stored procedure EF6 and; MVC from the interface in the repository model EXAMPLE
I am using MVC 5 and Entity Framework 6 Database First approach. I cannot find an example of calling a stored procedure in the interface and the return type is another problem as for example: My Select is as follows Create Procedure pcdSELECTEMPLOYEE
MySql stored procedures, transactions and demotions
I can't find an optimal way to use transactions in a MySql Stored Procedure. I want to ROLLBACK if anything fails: BEGIN SET autocommit=0; START TRANSACTION; DELETE FROM customers; INSERT INTO customers VALUES(100); INSERT INTO customers VALUES('wron
Stored Procedures sql and Bitwise Operators
I have a categories table: id;description;special ---------------------- 1;Spares;TRUE 2;Accessories;TRUE 4;Consumables;TRUE 8;Services;TRUE 11;Printer;FALSE 12;Monitor;FALSE 13;Other;FALSE The special field designates special categories that have fi
SQL Stored Procedure Date and Time Filter by Location
I have a problem with a stored procedure in SQL Server, there is a table with two datetime columns, a start time and an end time that I am filtering on based on location and entity. In a location report, when the filtering conditions for Start time a
Optimize the stored procedure update and select
The stored procedure I've created works, but is there a more efficient way of doing this? To be fair there is no performance hit for any of this nor does it need optimised but I'd like to know in the interest of doing things correctly. Execution plan
Put the database logic in the application instead of the trigger, stored procedures, constraints, and so on.
I'm using Rails and it does not provide support for database specific actions like triggers, stored procedures and various constraints (not all of them). I wonder if I should put the database logic in the application itself instead. Because then you
Change all views and stored procedures, find and replace?
Is there an easy way to do a find and replace on a string in every view and stored procedure in my SQL Server database. I need to replace something like 'X United Kingdom' with 'X(UK)'.You need to look at sysobjects and syscomments, the text of views
Stored procedures, MySQL and PHP
The question is a fairly open one. I've been using Stored Procs with MS SQLServer for some time with classic ASP and ASP.net and love them, lots. I have a small hobby project I'm working on and for various reasons have gone the LAMP route. Any hints/
Calling a stored procedure (A) from the stored procedure (B) and using the result set form A in B
In SQL server 2012 I am looking for a way to call a Stored Procedure (A) from stored Procedure (B). SP A returns a result set that I then will need to use in SP B. Is this possible?yes, with multiple columns too: create table tablea ( cola int, colb
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK