Laravel sql server execute stored procedure with array parameter

Question

I have a very simple question; I have a query running perfectly on sql server and I want to run this query using laravel framework, here is the query:

DECLARE @countries AS countryList; 
    INSERT INTO @countries SELECT countries.id FROM countries where countries.id in (1,2,3,4,9,11,14);
    EXEC sp_positionofCourtCasesofLoanDefaultA @countries

in Laravel this is returning 'true' always

 $result = DB::statement('DECLARE @countries AS countryList; INSERT INTO @countries SELECT countries.id FROM countries where countries.id in (' . $countries . ');
 EXEC sp_positionofCourtCasesofLoanDefaultA @countries');

 dd($result);

please help.

In SQL server this stored procedure returns records but in laravel it returns boolean. — Osama Alvi
– Osama Alvi, Commented Jul 31, 2017 at 13:47

Valen D'souza · Accepted Answer · 2017-11-10 09:50:49Z

1

i think DB:statement() returns either true or false. It is generally used in queries like insert in which no result is returned. So if the query was executed successfully it returns true otherwise returns false.

answered Nov 10, 2017 at 9:50

Valen D'souza

112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel sql server execute stored procedure with array parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related