CodeIgniter Forums
Empty data result in query MS SQLSERVER "OUTPUT INSERTED.*" - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Empty data result in query MS SQLSERVER "OUTPUT INSERTED.*" (/showthread.php?tid=70273)



Empty data result in query MS SQLSERVER "OUTPUT INSERTED.*" - nguyenthao - 03-16-2018

Hi Every body!

I using codeigniter Framework with database Microsoft SQL SERVER 2016.

I have T-SQL

Insert into tbl_student('subject', 'name')  output inserted.name values('laptrinhvb.net', 'Nguyễn Thảo')

I'm run T-sql in sqlserver management result => "Nguyễn Thảo".

I use T sql in php

$this->db->query("Insert into tbl_student('subject', 'name')  output inserted.name values('laptrinhvb.net', 'Nguyễn Thảo')")->row()->name;

Result data empty!

Please help me! Smile