我试图将它转换为与Laravel的DB类一起工作，除了它没有返回任何东西

Question

I am trying to convert my Sql Query to Laravel Query and I am getting Error :?

SQLSTATE[HY000]: General error: 2809 General SQL Server error: Check messages from the SQL Server [2809] (severity 18) [(null)] (SQL: GetRegisteredUserData)

My query1:

SELECT * FROM  RegisteredUser WHERE DateCreated between '$startDate' AND  '$endDate' ORDER BY Yr DESC,MnthNo DESC

My query2:

SELECT * from  UserData where((Yr * 10000 + Mnth * 100 + 1) BETWEEN $startDate AND $endDate) ORDER BY Yr Asc, Mnth Asc

Answer 1

In laravel 5 we have to do something like this below to execute a query from controller $query = DB::connection('sqlsrv')->select('SELECT * FROM RegisteredUser WHERE((Yr * 10000 + Mnth * 100 + 1) BETWEEN '.$startDate.' AND '.$endDate.')');

$startDate = 20160101 $endDate = 20160601