KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
stored-procedures
190 questions · page 2 of 4
Follow Tag
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 →