Cross Apply in SQL server 2017

i am trying to split String into multiple row using cross apply is it possible to use the cross apply in SQL server 2017? how to replace cross apply?

1 answer

  • answered 2017-08-16 19:28 Gordon Linoff

    You can use string_split() and apply:

    select . . .
    from t cross apply
         string_split(t.col, ',');