Questions tagged [stored-procedures]

51

votes

8

answers

SQL ignore part of WHERE if parameter is null

asked 2013-07-25T06:36:12.553

36

votes

4

answers

How to write a stored procedure in phpMyAdmin?

php mysql stored-procedures phpmyadmin

asked 2013-07-05T05:49:44.210

8

votes

1

answers

The SqlParameter is already contained by another SqlParameterCollection when NOT using a SqlParameterCollection

c# asp.net-mvc stored-procedures dbcontext

asked 2013-06-20T21:58:16.807

51

votes

13

answers

SQL Differences between stored procedure and triggers

sql stored-procedures triggers

asked 2013-05-18T20:07:05.870

12

votes

1

answers

Mysql CREATE DEFINER

mysql stored-procedures

asked 2013-05-16T18:31:28.770

45

votes

5

answers

Cannot find the user '', because it does not exist or you do not have permission

sql-server t-sql sql-server-2005 stored-procedures

asked 2013-04-16T15:06:41.443

10

votes

1

answers

Unable to get multiple Table entities through Stored procedure using hibernate

java mysql hibernate stored-procedures

asked 2013-01-30T16:19:28.187

11

votes

2

answers

syntax error on DECLARE CURSOR FOR

mysql stored-procedures

asked 2013-01-20T09:43:04.600

8

votes

1

answers

Entity Framework 5 Migrations creating procedures/functions

sql stored-procedures powershell entity-framework-5

asked 2012-11-29T09:51:45.503

10

votes

1

answers

MySQL temporary variable assignment

mysql stored-procedures

asked 2012-11-08T05:47:13.590

32

votes

2

answers

When should I use 'for update nowait' in cursors?

oracle-database stored-procedures oracle11g oracle10g database-cursor

asked 2012-11-06T09:39:25.207

13

votes

3

answers

ExecuteNonQuery() returns -1 when execute the stored procedure

c# sql sql-server visual-studio-2010 stored-procedures

asked 2012-10-17T10:40:05.650

10

votes

4

answers

How to join result of two sql statements into one table and different columns

sql sql-server stored-procedures

asked 2012-10-16T18:34:51.870

9

votes

2

answers

How to Pass Java List of Objects to Oracle Stored Procedure Using MyBatis?

oracle-database stored-procedures mybatis

asked 2012-10-04T02:56:14.410

12

votes

3

answers

Procedure in package specification

oracle-database stored-procedures plsql scope package

asked 2012-10-03T11:06:03.667

9

votes

1

answers

Dapper (connection.Query or connection.Execute)

stored-procedures execute dapper

asked 2012-10-02T16:06:05.107

15

votes

7

answers

JPA Hibernate Call Postgres Function Void Return MappingException:

hibernate function jpa stored-procedures postgresql-9.1

asked 2012-09-24T01:57:13.387

15

votes

2

answers

After SP Insert, next page have an empty result until reloaded

php mysql stored-procedures mysqli

asked 2012-08-26T14:40:19.227

30

votes

4

answers

SQL Server : stored procedure transaction

sql-server stored-procedures transactions

asked 2012-08-20T06:04:29.090

95

votes

4

answers

How to return the output of stored procedure into a variable in sql server

sql sql-server variables stored-procedures

asked 2012-08-15T07:02:35.823

21

votes

4

answers

SQL stored procedure IF EXISTS UPDATE ELSE INSERT

sql stored-procedures if-statement

asked 2012-08-10T22:59:15.260

9

votes

2

answers

Stored procedure vs embedded SQL in SSIS performance

sql-server t-sql stored-procedures ssis

asked 2012-07-06T09:10:18.747

13

votes

3

answers

Can I get the results of a stored procedure into a cursor within another stored procedure in SQL

sql sql-server sql-server-2008 stored-procedures database-cursor

asked 2012-07-05T10:21:02.900

9

votes

1

answers

how to declare %ROWTYPE of a variable that is a weakly typed SYS_REFCURSOR?

oracle-database stored-procedures plsql sys-refcursor rowtype

asked 2012-06-25T10:16:22.333

9

votes

4

answers

What is scope of temp table when called by nested stored procedure?

sql-server t-sql stored-procedures

asked 2012-06-20T04:28:20.827

8

votes

2

answers

PHP MYSQL Error when calling multiple Stored Procedures

php stored-procedures mysqli

asked 2012-05-24T20:50:05.737

13

votes

6

answers

Entity Framework - stored procedure return value

c# sql entity-framework stored-procedures

asked 2012-04-26T19:04:42.900

9

votes

9

answers

Javascript encodeURI like function in postgresql?

postgresql stored-procedures urlencode plpgsql

asked 2012-04-25T14:39:53.663

8

votes

2

answers

how to use openrowset to execute a stored procedure with parameters

sql-server-2008 t-sql stored-procedures openrowset

asked 2012-04-24T06:25:37.573

10

votes

4

answers

Is it possible to execute many stored procedures in a single operation?

c# .net stored-procedures ado.net

asked 2012-04-19T09:36:23.770

9

votes

1

answers

How can I fetch the data from the SYS_REFCURSOR from one stored proc and use it in another?

sql oracle-database stored-procedures database-cursor

asked 2012-04-05T18:50:13.490

9

votes

1

answers

How to use stored proc inside log4net configuration for SQL Server for logging

asp.net sql-server-2008 stored-procedures logging log4net

asked 2012-04-05T18:35:58.667

9

votes

2

answers

Unable to access table variable in stored procedure

c# sql-server-2008 stored-procedures

asked 2012-03-29T07:45:09.783

19

votes

2

answers

How do I reference named parameters in Postgres sql functions?

sql postgresql stored-procedures

asked 2012-03-19T13:58:09.950

81

votes

4

answers

Entity Framework Vs Stored Procedures - Performance Measure

entity-framework stored-procedures performance-testing database-performance

asked 2012-03-16T14:35:57.843

9

votes

4

answers

Paging, sorting and filtering in a stored procedure (SQL Server)

sql-server t-sql stored-procedures

asked 2012-03-13T21:38:45.010

10

votes

6

answers

Can I search stored procedure results?

sql sql-server-2005 stored-procedures

asked 2012-02-21T13:35:09.327

8

votes

2

answers

In MySQL how do I create a stored procedure that takes multiple parameters?

mysql database stored-procedures call

asked 2012-02-07T18:18:41.223

9

votes

3

answers

Ordering SQL Server results by IN clause

asp.net sql database sql-server-2008 stored-procedures

asked 2012-01-20T20:19:01.110

30

votes

3

answers

Solution to "cannot perform a DML operation inside a query"?

sql oracle-database function stored-procedures plsql

asked 2012-01-04T15:20:16.100

8

votes

3

answers

VBA - Generate Excel File from Access (QueryTable)

excel ms-access vba stored-procedures

asked 2012-01-03T17:47:21.010

10

votes

2

answers

Upsert SQL query

sql sql-server-2008 stored-procedures

asked 2012-01-02T13:39:18.877

17

votes

1

answers

Calling a user defined stored procedure from select statement mysql

mysql stored-procedures select

asked 2011-11-28T00:05:06.233

11

votes

3

answers

How to execute store procedure for another DB?

sql sql-server stored-procedures linked-server

asked 2011-11-21T05:13:36.760

75

votes

9

answers

Pass array to MySQL stored routine

mysql arrays stored-procedures parameter-passing

asked 2011-11-16T09:45:02.240

14

votes

3

answers

How can I download all stored procedures from a specific database

sql sql-server stored-procedures

asked 2011-11-16T06:06:40.173

12

votes

3

answers

How should I return an int from a stored procedure in entity framework 4.1?

c# stored-procedures entity-framework-4.1 sql-server-2008-r2

asked 2011-11-15T15:05:54.410

23

votes

2

answers

mysql while loop Break equivalent

mysql stored-procedures

asked 2011-11-14T16:55:29.100

9

votes

1

answers

Trying to call a T-SQL Stored Procedure which selects data from linked server in SSIS package

sql-server stored-procedures ssis linked-server

asked 2011-11-08T00:38:34.093

26

votes

3

answers

Existing state of packages has been discarded

sql oracle-database stored-procedures error-handling plsql

asked 2011-10-27T18:15:12.257

Questions tagged stored-procedures