Hi all,
I created a Linq to SQL class in C#.
Take the stored precedure in the dbml file.
Added a new Datasource (Type Object).
So i want to take the value of an Table that my Linq returns.
LeasinggesellschaftDataContext blabla = new LeasinggesellschaftDataContext();
blabla.getDetails(2);
MessageBox.Show(blabl...
Hi guys,
I wonder if any one may be able to help?
I have an issue with a SqlCommand object that when it executes a stored procedure that returns no records, will timeout.
The stored procedure is not complicated, it is just a simple SELECT ColumnA, ColumnB, ... FROM TableA WHERE Id = @Id type of thing. If I run the SP in Sql Managment ...
Hi,
I have recently started working on a legacy application that has most of its business logic in stored procedures spread over two or three SQL Server databases. Currently all code is also edited in the live environment.
As I am new to the codebase, I don't really want to make any changes in the live environment and therefore I'm try...
How do you view a stored procedure/function?
Say I have an old function without the original definition - I want to see what it is doing in pg/psql but I can't seem to figure out a way to do that.
using Postgres version 8.4.1
...
Hi,
I want to create generic function that will need only parameter as Stored procedure name and will return the collection of the parameter list of that stored procedure. how to achieve this in c#.
OR
another way :-
can we write the stored procedure that will have the parameter as names of another SP let say as varchar type, and will r...
I connect to an oracle database from an ASP-VBSCRIPT website and want to execute a stored procedure which accepts input parameters as well as returning some. The stored procedure is the following:
p_std_currency.get_currency_details(input1,input2,input3,input4,output1,output2)
Input 1-4 are the parameters (3rd is dat...
This is more to do with maintenance issues for a Rails app. Currently , it has a lot of stored procedures (Postgres -pgsql) and I 'm wondering if I should do away with them and translate them into Rails classes. Performance-wise would rails classes be a better idea than pgsql stored procs? Thanks!
...
We have a problem with our table schema falling out of sync with our view schema. I would like to know how I could have a stored procedure (for Sql Server) that gets all views in the database, and executes each one via select *
Here is what I imagined (pseudo):
Declare x
Set x = Select object from sysobjects where object = view
fore...
Hi All -
I'm running into some problems trying to import a Stored Procedure into a database running on my local MAMP server.
This is the procedure in question:
DELIMITER $$
CREATE PROCEDURE `ZipRangeFinder`(
zipbase VARCHAR(15),
rangex NUMERIC (15),
inter NUMERIC(15),
start NUMERIC(15),
rows NUMERIC(15)
)
B...
I've written a stored FUNCTION that calls itself, recursively.
However when I run it in a query I get this shameless error:
Error: 1424 SQLSTATE: HY000 (ER_SP_NO_RECURSION)
Message: Recursive stored functions and triggers are not allowed.
"Not allowed"?
Right. Why don't we just disable WHILE loops also, while we're at it?
...
I am looking for an ORM that supports stored procedures. I would like to implement something like this in perl, but I would like to look at the interface and abstractions in something already written for ideas. Does anyone know of any ORM that supports stored procedures?
...
Hello,
After some answer on a previous question (request over several schema), I try to write a stored procedure to select tables for several schemas (Each user have a schema).
create or replace public.select_simulations() returns setof simulation as $$
declare
users pg_user%ROWTYPE;
simu simulation%ROWTYPE;
begin
for user...
Can we call a stored procedure from a function in SQL? What's the reason?
...
Hello,
I am testing the permissions in mssql and run into a problem. I've made a 'Countries' table and a 'spCountries' Stored procedure. Now I've made a user 'silverlight' and gave it no rights to the Countries table. The user can execute the stored procedure.
Now when I do a Select it fails like it should, but in a exec spCountries, a...
I just need pass WHERE condition, like:
CREATE DEFINER=`root`@`localhost` PROCEDURE `productpricing2`(
IN cond CHAR(200)
)
BEGIN
SELECT * FROM tbl_products WHERE cond LIMIT 1;
END
and call it like:
CALL productpricing2("productName IS NOT NULL");
Where productName is column in table tbl_products
Thanks
...
Hi, I need to convert the text in the textbox of my xaml code to an integer value in C#. I am using .NET 4.0 and Visual Studio 2010. Is there a way to do it in xaml tags itself or do i need to write a converter in C sharp. I tried the following but is not working:
Convert.ToInt32(this.txtboxname.Text)
Any help is much appreciated. Tha...
I have a problem executing a stored procedure in Silverlight 4/RIA. The only value I get back is null. Am I doing my client and server side code wrong?
Client Side :
public ZipCodesDomainContext _ZipcodesDomainContext = new ZipCodesDomainContext();
/// <summary>
/// Creates a new <see cref="MainPage"/> instance.
...
I am trying to convince someone that using an external DLL to manage sql data is better then using stored procedures. Currently the person I am working with is using vba and calls sql stored procedures to get the complicated data they need from many different sources. It is my understanding that the best way to go about this kind of acti...
As a follow-up to the question "Get resultset from oracle stored procedure", is there a way to show the results of a stored procedure that returns a REFCURSOR in a grid (instead of the plain text Script Output window) within SQL Developer?
EDIT: The answer helped, but I'm still having a problem displaying the result set in the "View Val...
Hi,
I have a table in SQL Server 2005, as follows, say, fields A, B, C, D
If I have the following data:
A B C D
1 B1 C1 D1 -
2 B1 C1 D1 -
3 B2 C2 D2 -
4 B2 C2 D2 -
5 B2 C2 D2 -
6 B3 C3 D3 -
I want to be able to pick out the rows which are either unique (on B, C...