Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Execute stored procedure

------- sql server 
EXEC ProcedureName
EXEC ProcedureName(parameter1, parameter2, ... )

-------MySQL
CALL ProcedureName();
CALL ProcedureName(parameter1, parameter2, ... );

-------- Oracle
EXECUTE ProcedureName;
or 
begin 
    ProcedureName;
end;
EXECUTE ProcedureName ('arg1', 'arg2');









Comment

run stored procedure sql

-- Datagrip: 
call MY_SCHEMA.my_procedure();
-- SQL Developer
exec MY_SCHEMA.my_procedure();
-- Shorter than :
BEGIN
	MY_SCHEMA.my_procedure();
END;
Comment

TSQL: How to execute a stored procedure

USE [Databse]
GO
EXEC [Procedure];
Comment

PREVIOUS NEXT
Code Example
Sql :: sql change column name based on value 
Sql :: Select All From A Table In A MySQL Database 
Sql :: sql highest salary by location 
Sql :: sql rename column in select 
Sql :: connect by query in oracle 
Sql :: SQL Server Splitting a string column into multiple rows, while repeating ID column 
Sql :: array aggre distinct postgres 
Sql :: download database devilbox 
Sql :: php mysql select current month 
Sql :: create postgres role and database for bitbucket 
Sql :: select where mysql 
Sql :: compare field sql server 
Sql :: mysql check all tables 
Sql :: psql command not found windows 
Sql :: mysql error the maximum column size is 767 bytes. 
Sql :: mysql get table column names and data types 
Sql :: cql insert 
Sql :: oracle all columns 
Sql :: get string between specific character sql 
Sql :: update query in sql 
Sql :: database stuck at restoring state 
Sql :: merge command in sql 
Sql :: sql quary intervewi question 
Sql :: open cursors in oracle 
Sql :: sql select maximum column with other columns returned 
Sql :: mysql show create db 
Sql :: sql delete table 
Sql :: not null sql 
Sql :: sql in operator 
Sql :: SQL JOIN and Aliases 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =