How to use Function name in Stored procedure

Question

1) How to write a function using comma separator in sql? 2) How to write a function name inside the stored procedure?

Shubham Kumar · Answer

Hi Deepak just check the link you will get an idea how to use function in sp http://www.c-sharpcorner.com/UploadFile/rohatash/calling-a-function-from-a-stored-procedure-in-sql-server-201/

Upendra Pratap Shahi · Answer

1- How to create function in SQL- USE [your database name] GO /****** Object: UserDefinedFunction [dbo].[fnSplit] Script Date: 02.06.2015 4:02:02 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[fnSplit] ( @sInputList VARCHAR(MAX)  @sDelimiter VARCHAR(MAX) = '' ) RETURNS @List TABLE (item VARCHAR(8000)) BEGIN DECLARE @sItem VARCHAR(8000) WHILE CHARINDEX(@sDelimiter @sInputList 0) 0 BEGIN SELECT @sItem = RTRIM( LTRIM(SUBSTRING(@sInputList 1 CHARINDEX(@sDelimiter @sInputList 0) -1)) ) @sInputList = RTRIM( LTRIM( SUBSTRING( @sInputList CHARINDEX(@sDelimiter @sInputList 0) + LEN(@sDelimiter) LEN(@sInputList) ) ) ) IF LEN(@sItem) > 0 INSERT INTO @List SELECT @sItem END IF LEN(@sInputList) > 0 INSERT INTO @List SELECT @sInputList RETURN END --SELECT * FROM [dbo].[fnSplit]('UPENDRA''') 2- How to use function- select * from your_tablename where couserid in(select * from dbo.fnSplit('upendraamitankur''')) if helpful mark This is correct answer