CODEWITHSUNDEEP
sql-server
Rab
Rab

Reputation: 159

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?

Upvotes: 1

Views: 239

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271023

You can use string_split() and apply:

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

Upvotes: 3

Related Questions