Top "Stored-procedures" questions

A subroutine available to applications accessing a relational database system.

SQL Server Insert if not exists

I want to insert data into my table, but insert only data that doesn't already exist in my database. Here …

sql sql-server sql-server-2008 stored-procedures
Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call …

c# asp.net sql-server stored-procedures ado.net
Must declare the scalar variable

@RowFrom int @RowTo int are both Global Input Params for the Stored Procedure, and since I am compiling the SQL …

sql sql-server stored-procedures
List of Stored Procedures/Functions Mysql Command Line

How can I see the list of the stored procedures or stored functions in mysql command line like show tables; …

mysql stored-procedures command-line
How to check if a stored procedure exists before creating it

I have a SQL script that has to be run every time a client executes the "database management" functionality. The …

sql sql-server tsql stored-procedures
What is a stored procedure?

What is a "stored procedure" and how do they work? What is the make-up of a stored procedure (things each …

sql sql-server tsql stored-procedures
SQL Server SELECT into existing table

I am trying to select some fields from one table and insert them into an existing table from a stored …

sql sql-server tsql stored-procedures
Run Stored Procedure in SQL Developer?

I am trying to run a stored procedure that has multiple in and out paramaters. The procedure can only be …

oracle stored-procedures oracle-sqldeveloper
How to call Stored Procedure in Entity Framework 6 (Code-First)?

I am very new to Entity Framework 6 and I want to implement stored procedures in my project. I have a …

c# entity-framework stored-procedures
How to declare an array inside MS SQL Server Stored Procedure?

I need to declare 12 decimal variables, corresponding to each month's year, with a cursor I sum values to this variables, …

sql-server-2008 stored-procedures