Alex Rivera | Logout

Questions tagged stored-procedures

190 questions · page 2 of 4

Sort by: Newest Votes Active
13
votes
5
answers

MySQL queries are fast when run directly but really slow when run as stored proc

mysql sql stored-procedures
asked 2011-10-24T10:02:45.410
13
votes
3
answers

Oracle: Using a database link in a stored procedure : table or view does not exist

sql database oracle-database stored-procedures dblink
asked 2011-10-20T17:05:40.043
22
votes
6
answers

Find Stored Procedure that Inserts Into a Specific Table

sql sql-server database sql-server-2008 stored-procedures
asked 2011-09-09T15:06:10.330
12
votes
2
answers

dbms_scheduler.run_job('jobName) fails to run

oracle-database stored-procedures plsql dbms-scheduler
asked 2011-08-25T10:13:48.947
25
votes
4
answers

Best practices of structuring stored procedures

sql stored-procedures
asked 2011-08-24T19:21:51.253
15
votes
7
answers

oracle systimestamp (sysdate) to milliseconds

database oracle-database stored-procedures
asked 2011-08-22T13:11:19.107
28
votes
3
answers

SQL Stored Procedure: If variable is not null, update statement

sql t-sql stored-procedures sql-update
asked 2011-08-18T17:58:12.130
9
votes
2
answers

How to fix the error procedure expects parameter '@parameters' of type 'ntext/nchar/nvarchar'?

sql sql-server stored-procedures asp-classic
asked 2011-08-01T21:04:43.270
13
votes
2
answers

Compiling Stored Procedure hangs Oracle SQL Developer

stored-procedures oracle10g compilation oracle-sqldeveloper
asked 2011-07-23T11:33:29.563
62
votes
4
answers

How to schedule a stored procedure in MySQL

mysql database stored-procedures mysql-routines
asked 2011-07-03T01:50:55.620
18
votes
2
answers

Fetch Oracle table type from stored procedure using JDBC

oracle-database stored-procedures jdbc resultset out-parameters
asked 2011-06-20T11:29:08.227
18
votes
6
answers

TransactionScope maximumTimeout

c# sql stored-procedures app-config transactionscope
asked 2011-06-19T11:12:05.103
80
votes
10
answers

"This SqlTransaction has completed; it is no longer usable."... configuration error?

sql stored-procedures sql-server-2008-r2 server-error
asked 2011-06-15T13:54:35.220
65
votes
5
answers

Execute Stored Procedure from a Function

sql sql-server sql-server-2005 stored-procedures user-defined-functions
asked 2011-06-14T14:11:54.330
11
votes
3
answers

When to write a long stored procedure

stored-procedures
asked 2011-06-13T20:39:21.970
19
votes
9
answers

C# stored procedure with parameters

c# sql stored-procedures
asked 2011-06-01T13:15:46.423
9
votes
1
answers

PostgreSQL Conditional Join

sql database postgresql stored-procedures join
asked 2011-05-29T14:42:58.627
18
votes
13
answers

How can I generate a temporary table filled with dates in SQL Server 2000?

sql t-sql stored-procedures sql-server-2000
asked 2011-05-25T13:50:01.170
16
votes
3
answers

Is a return value of 0 always a success in stored procedures?

sql-server sql-server-2008 stored-procedures
asked 2011-05-17T17:30:21.680
119
votes
6
answers

Current executing procedure name

sql-server sql-server-2008 t-sql stored-procedures
asked 2011-05-17T17:08:05.493
9
votes
5
answers

Execute a SQL Stored Procedure and process the results

vb.net t-sql sql-server-2008 stored-procedures
asked 2011-05-13T12:32:04.227
245
votes
7
answers

Is there a way to call a stored procedure with Dapper?

.net stored-procedures orm dapper
asked 2011-05-11T09:35:51.563
14
votes
6
answers

How to find which columns don't have any data (all values are NULL)?

sql sql-server t-sql sql-server-2008 stored-procedures
asked 2011-05-04T18:14:18.777
16
votes
4
answers

PostgreSQL function or stored procedure that outputs multiple columns?

postgresql stored-procedures plpgsql sql-function
asked 2011-03-28T17:49:30.633
23
votes
3
answers

How do I return XML from a Stored Procedure?

c# .net xml stored-procedures
asked 2011-03-24T18:48:19.297
31
votes
3
answers

SQL problem with error "Invalid data type"

sql sql-server t-sql sql-server-2008 stored-procedures
asked 2011-02-17T05:26:19.603
22
votes
5
answers

Is it possible to use a Stored Procedure as a subquery in SQL Server 2008?

sql-server stored-procedures subquery
asked 2011-02-03T17:40:32.713
14
votes
1
answers

SQL Server: Effects of using 'WITH RECOMPILE' in proc definition?

sql-server t-sql stored-procedures recompile
asked 2011-01-28T17:15:49.467
16
votes
2
answers

Function that would return the data retrieved from a select query - Oracle

oracle-database function stored-procedures plsql return
asked 2011-01-20T16:20:58.937
79
votes
7
answers

SQL Server silently truncates varchar's in stored procedures

sql sql-server stored-procedures truncate truncation
asked 2011-01-07T17:05:55.960
17
votes
2
answers

What is an Extended Stored Procedure in MS SQL Server?

sql-server stored-procedures sql-server-2005 database-administration definition
asked 2011-01-05T11:11:19.633
16
votes
1
answers

Any difference in performance/compatibility of different languages in PostgreSQL?

database postgresql stored-procedures plpgsql
asked 2010-12-25T23:59:21.640
26
votes
3
answers

Get the number of affected rows in a MySQL update statement?

sql mysql stored-procedures
asked 2010-11-29T17:04:56.833
15
votes
5
answers

Granting Rights on Stored Procedure to another user of Oracle

oracle-database stored-procedures sql-grant owner rights-management
asked 2010-11-29T15:43:33.933
14
votes
3
answers

Is it possible for a trigger to find the name of the stored procedure that modified data?

sql-server-2005 stored-procedures triggers
asked 2010-11-23T21:45:00.740
10
votes
4
answers

oracle "table or view does not exist" from inside stored procedure

oracle-database stored-procedures
asked 2010-11-16T19:18:56.303
29
votes
1
answers

What does this Oracle SQL Developer icon mean on my stored procedure?

oracle-database stored-procedures oracle-sqldeveloper
asked 2010-11-12T21:48:01.587
86
votes
3
answers

Inserting rows into a table with one IDENTITY column only

sql sql-server t-sql stored-procedures
asked 2010-11-07T12:22:37.750
16
votes
7
answers

How to migrate stored procedures to testing db?

mysql ruby-on-rails-3 testing stored-procedures
asked 2010-11-05T17:42:27.857
471
votes
7
answers

SQL Server SELECT into existing table

sql sql-server t-sql stored-procedures
asked 2010-11-04T21:49:42.100
21
votes
3
answers

Entity Framework stored procedure with multiple resultsets?

entity-framework stored-procedures
asked 2010-11-03T11:19:35.300
36
votes
8
answers

Calling Oracle stored procedure from C#?

c# .net oracle-database stored-procedures ado.net
asked 2010-10-15T08:22:31.427
18
votes
1
answers

How to handle multiple ResultSets, each with multiple Rows? IDataReader.NextResult() ending Read()

c# stored-procedures datareader
asked 2010-10-01T15:10:30.920
44
votes
5
answers

Stored Procedure and Permissions - Is EXECUTE enough?

sql-server stored-procedures permissions
asked 2010-09-28T17:26:51.317
12
votes
2
answers

How to identify the caller of a Stored Procedure from within the Sproc

sql sql-server-2008 stored-procedures diagnostics
asked 2010-09-10T18:01:09.563
71
votes
3
answers

SQL Server - How to lock a table until a stored procedure finishes

sql sql-server t-sql stored-procedures locking
asked 2010-09-07T21:06:24.627
9
votes
7
answers

Determining if MySQL table index exists before creating

mysql stored-procedures indexing
asked 2010-09-02T11:28:08.347
29
votes
5
answers

How to pass XML from C# to a stored procedure in SQL Server 2008?

c# sql-server xml stored-procedures sqlparameter
asked 2010-08-30T11:59:50.413
61
votes
9
answers

stored procedures with sqlAlchemy

python sql-server stored-procedures sqlalchemy
asked 2010-08-25T07:34:20.917
11
votes
1
answers

Oracle SQL Developer: Show REFCURSOR Results in Grid?

oracle-database stored-procedures oracle-sqldeveloper
asked 2010-08-24T12:22:24.167
← Prev page 2 of 4 Next →