Alex Rivera | Logout

Questions tagged stored-procedures

190 questions · page 3 of 4

Sort by: Newest Votes Active
12
votes
2
answers

SQL Error 1630: Function SUBSTRING does not exist.. huh?

mysql stored-procedures
asked 2010-08-17T22:04:47.273
40
votes
7
answers

How to get rid of "Error 1329: No data - zero rows fetched, selected, or processed"

sql mysql stored-procedures
asked 2010-08-11T22:15:00.153
9
votes
8
answers

Using Stored Procedures as the Business Logic Layer

sql-server stored-procedures
asked 2010-07-20T23:06:20.073
28
votes
5
answers

Using UPDATE in stored procedure with optional parameters

sql-server stored-procedures
asked 2010-07-20T13:51:23.120
11
votes
2
answers

Entity framework calling a FOR XML stored procedure truncates at 2033 characters

entity-framework stored-procedures .net-4.0 for-xml
asked 2010-07-12T12:03:20.740
14
votes
5
answers

Sybase: get list of stored procedures using a particular table

stored-procedures sybase
asked 2010-06-30T11:21:27.780
20
votes
5
answers

How can I use Oracle SQL developer to run stored procedures?

oracle-database stored-procedures plsql oracle-sqldeveloper sys-refcursor
asked 2010-06-28T18:05:17.037
10
votes
5
answers

SQL: Splitting a column into multiple words to search user input

sql sql-server stored-procedures
asked 2010-06-26T11:12:20.230
26
votes
2
answers

What is the scope of CONTEXT_INFO in SQL Server?

sql-server sql-server-2008 stored-procedures triggers context-info
asked 2010-06-11T19:31:04.080
21
votes
8
answers

How to use a value from one stored procedure in another?

sql sql-server-2008 stored-procedures return-value parameters
asked 2010-06-08T09:53:00.453
12
votes
3
answers

SQL Server stored procedure line number issue

sql-server-2008 stored-procedures deadlock
asked 2010-06-01T03:50:50.090
17
votes
6
answers

Ad hoc queries vs stored procedures vs Dynamic SQL

sql stored-procedures dynamic-sql adhoc-queries
asked 2010-05-29T10:19:31.920
12
votes
3
answers

How to use local variables in stored procedures?

sql sql-server stored-procedures variables
asked 2010-05-27T12:31:19.720
18
votes
3
answers

oracle call stored procedure inside select

sql oracle-database stored-procedures plsql insert
asked 2010-05-19T11:50:24.550
13
votes
3
answers

Is it possible to create a global stored procedure at Sql server level

sql sql-server database stored-procedures function
asked 2010-04-21T07:02:53.150
10
votes
3
answers

Generating the SQL query plan takes 5 minutes, the query itself runs in milliseconds. What's up?

sql sql-server t-sql sql-server-2008 stored-procedures
asked 2010-04-11T00:37:24.230
9
votes
1
answers

Stored procedure modified time

sql-server t-sql stored-procedures
asked 2010-03-23T00:17:19.360
13
votes
4
answers

How to pass a variable number of parameters to a SQL Server stored procedure?

sql-server stored-procedures parameters
asked 2010-03-21T01:47:40.133
14
votes
4
answers

How do I get the list of all stored procedures and their parameters starting with a certain prefix?

sql-server stored-procedures sql-server-2000
asked 2010-02-28T11:38:53.407
17
votes
3
answers

Spring's Stored Procedure - results coming back from procedure always empty

java oracle-database stored-procedures jdbc spring-jdbc
asked 2010-01-28T12:17:53.197
17
votes
3
answers

How to call a stored procedure in IBM System i Access for Windows GUI Tool

stored-procedures db2 ibm-midrange
asked 2010-01-22T17:13:26.597
22
votes
3
answers

Advantage of using Views in MySQL

mysql stored-procedures view
asked 2010-01-13T07:02:29.853
10
votes
5
answers

MySQL stored procedure, handling multiple cursors and query results

mysql sql stored-procedures database-cursor
asked 2010-01-03T14:55:50.800
108
votes
10
answers

Show procedure definition in MySQL

sql mysql database stored-procedures stored-functions
asked 2009-12-28T10:06:24.463
24
votes
5
answers

Most Executed Stored Procedure?

sql sql-server database t-sql stored-procedures
asked 2009-12-21T21:28:06.447
19
votes
2
answers

Simple Math max function in MySQL

sql mysql math stored-procedures
asked 2009-12-17T02:03:52.543
10
votes
2
answers

SQL error: String or binary data would be truncated

sql-server exception stored-procedures telligent blogml
asked 2009-12-11T15:05:07.153
12
votes
2
answers

Classic ADO and Table-Valued Parameters in Stored Procedure

sql-server stored-procedures vb6 ado
asked 2009-12-10T20:39:13.517
19
votes
3
answers

Retrieving Multiple Result sets with stored procedure in php/mysqli

php stored-procedures mysqli resultset
asked 2009-11-05T21:33:30.103
27
votes
4
answers

pl/sql stored procedure: parameter name same as column name

oracle-database stored-procedures plsql
asked 2009-10-22T15:07:40.323
50
votes
11
answers

SQL-Server Performance: What is faster, a stored procedure or a view?

sql sql-server stored-procedures view
asked 2009-10-21T21:47:34.107
16
votes
13
answers

Cannot find the object "XXX" because it does not exist or you do not have permission

sql-server stored-procedures permissions
asked 2009-10-21T15:19:20.780
464
votes
15
answers

How to SELECT FROM stored procedure

sql sql-server sql-server-2005 stored-procedures
asked 2009-09-29T13:05:57.613
10
votes
2
answers

How to store selection result in to variable in Oracle procedure

oracle-database stored-procedures select-into
asked 2009-08-28T13:46:29.000
13
votes
3
answers

How do I write a postgres stored procedure that doesn't return anything?

postgresql stored-procedures plpgsql
asked 2009-08-27T21:55:31.033
20
votes
4
answers

How do I delete a stored procedure in Postgresql?

postgresql stored-procedures
asked 2009-08-27T20:44:12.863
158
votes
10
answers

How can I check if a View exists in a Database?

sql sql-server database stored-procedures view
asked 2009-08-20T12:54:41.887
28
votes
8
answers

SQL Server SELECT INTO and Blocking With Temp Tables

sql-server stored-procedures temp-tables sqlperformance
asked 2009-08-19T21:18:53.263
44
votes
6
answers

SQL Update Multiple Fields FROM via a SELECT Statement

sql sql-server stored-procedures sql-update
asked 2009-08-12T18:45:54.473
39
votes
12
answers

SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes

sql sql-server stored-procedures sql-server-2005 parameter-sniffing
asked 2009-08-12T09:52:33.213
77
votes
8
answers

How to pass a null variable to a SQL Server stored procedure from C# / .NET code

c# sql sql-server stored-procedures
asked 2009-07-30T15:36:39.620
1028
votes
19
answers

Function vs. Stored Procedure in SQL Server

sql sql-server t-sql stored-procedures sql-function
asked 2009-07-24T19:40:06.827
35
votes
6
answers

Dynamic order direction

sql sql-server stored-procedures sql-order-by case
asked 2009-07-18T15:10:00.887
95
votes
15
answers

How to compare values which may both be null in T-SQL

sql sql-server t-sql stored-procedures
asked 2009-07-02T15:42:17.970
39
votes
6
answers

The "right" way to do stored procedure parameter validation

sql sql-server stored-procedures error-handling
asked 2009-06-29T12:10:40.163
62
votes
7
answers

Using a cursor with dynamic SQL in a stored procedure

t-sql stored-procedures dynamic-sql database-cursor
asked 2009-06-25T19:51:49.187
9
votes
3
answers

How to retrieve scalar value from stored procedure (ADO.NET)

sql sql-server-2008 stored-procedures ado.net
asked 2009-06-25T13:17:49.017
10
votes
3
answers

CLR SQL Stored Procedures Testing with Unit Test Project

sql unit-testing stored-procedures clr
asked 2009-06-22T17:43:09.960
12
votes
5
answers

What is a stored procedure with a padlock icon in SQL Server 2005?

stored-procedures sql-server-2005 locking
asked 2009-06-22T14:29:03.150
14
votes
3
answers

C# Oracle Stored Procedure Parameter Order

c# oracle-database stored-procedures
asked 2009-06-06T08:20:11.863
← Prev page 3 of 4 Next →