Split strings in SQL Server

Declare @ ABC varchar (50) set @ abc = '2014, 2008,200 '; declare @ temp varchar (50) Declare @ sign varchar (50) declare @ run bit -- the flag for continuing the loop: Set @ run = 1; while (@ run = 1) beginif (LEN (@ ABC)> 0) -- If the table name set is not empty, perform the following operations: beginset @ sign = charindex (',', @ ABC); If (@ sign = 0) -- If 'is not found,' indicates that @ ABC has only one beginset @ temp = @ ABC; Set @ run = 0; endelsebeginset @ temp = substring (@ ABC, 1, @ sign-1) -- table name set @ abc = substring (@ ABC, @ sign + 1, Len (@ ABC )) -- shorten the length of the string storing the table name to the last endprint @ temp; endend