Stored Procedures in Laravel

How to use stored procedure in laravel

DB::select('exec my_stored_procedure("Param1", "param2",..)');
or

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));
Try this for without parameters

DB::select('EXEC my_stored_procedure')

Source: stackoverflow.com

Stored Procedures in Laravel

DB::connection("sqlsrv")->statement('exec Pro_Internal_Transfer_Note_post @mvoucherid='.$VMID);

Source: stackoverflow.com

Similar codes

0 vote209 views3 answers
Laravel sync with attributes
PHP
3 votes167 views3 answers
Php print array nice format
PHP
0 vote179 views3 answers
Move_uploaded_file
PHP
2 votes192 views2 answers
Get all sort by laravel
PHP Laravel
10 votes173 views3 answers
Php how to loop through array_rand
PHP
9 votes178 views4 answers
Could not open input file: artisan
PHP
12 votes176 views6 answers
Php convert datetime to timestamp
PHP
0 vote194 views1 answer
Get all users created in a month laravel
PHP Laravel
2 votes198 views2 answers
How to use stored procedure in laravel
PHP Laravel
0 vote174 views1 answer
Laravel redirect to previous page
PHP