Right click on function name (under programmability/functions) and right click the function. Error box pops up, won't let me make an edit.
Error:
Message : Specified cast is not valid.
Stack Trace:
at Quest.Toad.SqlServer.Trl.Udfs.UdfTableParameterColumnsTrl.QueryDone_EventHandler(Object sender, EventArgs e)
at Quest.Toad.Trl.BaseSqlTrl.CompletelyDone(Boolean hasLock)
at Quest.Toad.Trl.BaseSqlTrl.Done(Object sender, EventArgs args)
at Quest.Toad.Trl.BaseSqlTrl.InternalDone(Object sender, EventArgs e)
sample function:
CREATE FUNCTION Iter_FloatListToTable (@list nvarchar(MAX))
RETURNS @tbl TABLE (listpos int IDENTITY(1, 1) NOT NULL,
number float NOT NULL) AS
BEGIN
DECLARE @startpos int,
@endpos int,
@textpos int,
@chunklen smallint,
@str nvarchar(4000),
@tmpstr nvarchar(4000),
@leftover nvarchar(4000)
SET @textpos = 1
SET @leftover = ''
WHILE @textpos <= datalength(@list) / 2
BEGIN
SET @chunklen = 4000 - datalength(@leftover) / 2
SET @tmpstr = ltrim(@leftover +
substring(@list, @textpos, @chunklen))
SET @textpos = @textpos + @chunklen
SET @startpos = 0
SET @endpos = charindex(' ' COLLATE Slovenian_BIN2, @tmpstr)
WHILE @endpos > 0
BEGIN
SET @str = substring(@tmpstr, @startpos + 1,
@endpos - @startpos - 1)
IF @str <> ''
INSERT @tbl (number) VALUES(convert(float, @str))
SET @startpos = @endpos
SET @endpos = charindex(' ' COLLATE Slovenian_BIN2,
@tmpstr, @startpos + 1)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center