SQL Create field information (table-valued function)

1 ALTER FUNCTION [dbo].[fnt_splitstring]2 (3     @p1 varchar(Max),4     @p3 varchar(255)5 )6 RETURNS 7 @Table_Var TABLE 8 (9C1varchar(Max)Ten ) One  as A BEGIN -     Declare @p2 varchar(Max) -     Set @p2=RTrim(LTrim(@p1)) the     Declare @pos1 int -     Declare @pos2 int -     Set @pos1=1 -     Set @pos2=1 +      while(@pos1<Len(@p2)) -     begin +         Set @pos1=charindex(@p3,@p2) A         if(@pos1=0) at         begin -             Insert  into @table_var Values(@p2) -             Set @pos1=Len(@p2) -         End -         Else -         begin in             Insert  into @table_var Values( Left(@p2,@pos1-1)) -             Set @p2=right(@p2,Len(@p2)-@pos1) to             Set @pos1=0 +         End -     End the     RETURN  * END $ Panax Notoginseng 'Invocation Mode - Select C1, (Row_number () over (Order by @ @Cursor_Rows)) as C2 from dbo. Fnt_splitstring ('Id,wbs,quantity,mpsno,attribute,filecontent,materielname,materielcode,exportaccount',',')

SQL Create field information (table-valued function)