Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by xlncsql

  1. xlncsql

    Problem with functions return statement

    In the above example instead of returning a table cant we return a variable can some one explane it
  2. xlncsql

    Problem with functions return statement

    I did make the changes how ever the function is created but its not giving me expected results I am guessing its because of return not in the loop if can you explane me it just returns NULL as of now
  3. xlncsql

    Problem with functions return statement

    This function is splitting the string 'm1,m2,m3' into m1 m2 m3 I made few more correction can you check this create function fun_split ( @string varchar(20) ) RETURN char(5) begin declare @b int,@c varchar(5), @d varchar(5) set @d = replace('@string',',','.') set @b=0 while(@b<4) begin...
  4. xlncsql

    Problem with functions return statement

    Hi I am beginner to sqlserver and facinf a problem with functions can I get some help on it. Here is my programm create function fun_split ( @string varchar(20) ) RETURN char(5) begin declare @b int,@c char(5) set @string = replace('m1,m2,m3',',','.') set @b=0 while(@b<4) begin...
See more

Part and Inventory Search

Back
Top