CREATE FUNCTION DBO.SPLIT
(
@LIST NVARCHAR(2000),
@SPLITON NVARCHAR(5)
)
RETURNS @RTNVALUE TABLE
(
ID INT IDENTITY(1,1),
VALUE NVARCHAR(100)
)
AS
BEGIN
WHILE (CHARINDEX(@SPLITON,@LIST)>0)
BEGIN
INSERT INTO @RTNVALUE (VALUE)
SELECT
VALUE = LTRIM(RTRIM(SUBSTRING(@LIST,1,CHARINDEX(@SPLITON,@LIST)-1)))
SET @LIST = SUBSTRING(@LIST,CHARINDEX(@SPLITON,@LIST)+LEN(@SPLITON),LEN(@LIST))
END
INSERT INTO @RTNVALUE (VALUE)
SELECT VALUE = LTRIM(RTRIM(@LIST))
RETURN
END
Friday, 15 July 2011
Split Function in Sql
Wednesday, 13 July 2011
Pass Eval as Argument Of Javascript Function
<input type="button" id="but1" onclick="myFunction('<%# Eval("id") %>','<%# Eval("name")%>' )" />
Subscribe to:
Comments (Atom)