Conversion of MySQL queries to SQl Server queries in drupal application

Question

I am migrating my database from MySQl to SQL Server. My app is built on top of drupal. I am not able to convert the following code to its SQL Server equivalent : addExpression("GROUP_CONCAT(qa.answer SEPARATOR ',') ", 'lookingfordetails').

What is the SQL Server equivalent of GROUP_CONCAT() and how do I implement it in addExpression()?

See stackoverflow.com/questions/17591490/… - note that it does depend on your version of SQL Server (it can be painful, but is always do-able). — MandyShaw
– MandyShaw, Commented Jul 13, 2018 at 7:18
you can use Stuff function. Check the below link for reference — Deepak Kumar
– Deepak Kumar, Commented Jul 13, 2018 at 8:57

Daniela · Accepted Answer · 2018-07-13 09:15:39Z

1

I don't know if this works because I can't test it, but I suggest something like this:

$expression = 'STUFF((SELECT ',' + answer as lookingfordetails FROM table FOR XML PATH('')),1 ,1 ,'')';

$query->addExpression($expression);

I think you could see group_concat conversion to other databases: http://www.sqlines.com/mysql/functions/group_concat

answered Jul 13, 2018 at 9:15

Daniela

4543 silver badges9 bronze badges

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

1 Comment

dresh Over a year ago

will test this out and confirm back.

Collectives™ on Stack Overflow

Conversion of MySQL queries to SQl Server queries in drupal application

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related