Laravel how to call a function in sql server

Question

I am working with Laravel and I am using a database in Sql Server. I need to execute a function that was do in Sql Server but I do not how to execute it.

The function in Sql Server is something that it:

Select dbo.functionName (848,95,37)

I try to execute it with this:

DB::connection('database')->select('Select dbo.functionName ?,?,?',array(848,95,37))

but Laravel return it: Cannot access empty property

I hope you can help me.

Samira kalantari · Accepted Answer · 2017-04-17 09:52:24Z

3

I had this problem too, i solved that like this:

DB::connection('database')->select('Select dbo.functionName (?,?,?) as result',array(848,95,37))

answered Apr 17, 2017 at 9:52

Samira kalantari

3201 gold badge2 silver badges17 bronze badges

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

Comments

DatabaseCoder · Accepted Answer · 2016-09-14 19:37:01Z

2

May be this will work (Added parenthesis)

DB::connection('database')->select('Select dbo.functionName (?,?,?)',array(848,95,37))

answered Sep 14, 2016 at 19:37

DatabaseCoder

2,0522 gold badges15 silver badges22 bronze badges

Collectives™ on Stack Overflow

Laravel how to call a function in sql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related