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!
-
Congratulations bkrike 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
-
Problem with functions return statement
In the above example instead of returning a table cant we return a variable can some one explane it- xlncsql
- Post #7
- Forum: Microsoft SQL Server: Programming
-
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- xlncsql
- Post #6
- Forum: Microsoft SQL Server: Programming
-
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...- xlncsql
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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...- xlncsql
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
