Tip: generate error. declare @Day int, @Config_Node varchar(50) set @Config_Node=”value to trace” set @Day = @Config_Node You will get this message: Conversion failed when converting the varchar value ‘value to trace’ to data type int.
You should use Application.Volatile in the top of your function: Function doubleMe(d) Application.Volatile doubleMe = d * 2 End Function It will then reevaluate whenever the workbook changes (if your calculation is set to automatic).
In SQL Server 2012 you can use EOMONTH (Transact-SQL) to get the last day of the month and then you can use DAY (Transact-SQL) to get the number of days in the month. DECLARE @ADate DATETIME SET @ADate = GETDATE() SELECT DAY(EOMONTH(@ADate)) AS DaysInMonth
You can call source(“abc.R”) followed by source(“xyz.R”) (assuming that both these files are in your current working directory. If abc.R is: fooABC <- function(x) { k <- x+1 return(k) } and xyz.R is: fooXYZ <- function(x) { k <- fooABC(x)+1 return(k) } then this will work: > source(“abc.R”) > source(“xyz.R”) > fooXYZ(3) [1] 5 > … Read more
If someFunction is globally available, then you can cache the function, create your own, and have yours call it. So if this is the original… someFunction = function() { alert(“done”); } You’d do this… someFunction = (function() { var cached_function = someFunction; return function() { // your code var result = cached_function.apply(this, arguments); // use … Read more
There are two flavors of table valued functions. One that is just a select statement and one that can have more rows than just a select statement. This can not have a variable: create function Func() returns table as return select 10 as ColName You have to do like this instead: create function Func() returns … Read more
You can use CAST to throw meaningful error: create function dbo.throwError() returns nvarchar(max) as begin return cast(‘Error happened here.’ as int); end Then Sql Server will show some help information: Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value ‘Error happened here.’ to data type int.
You could do something like this: var a = (function() { var original_a = a; if (condition) { return function() { new_code(); original_a(); } } else { return function() { original_a(); other_new_code(); } } })(); Declaring original_a inside an anonymous function keeps it from cluttering the global namespace, but it’s available in the inner functions. … Read more
Try this function: Create Function [dbo].[RemoveNonAlphaCharacters](@Temp VarChar(1000)) Returns VarChar(1000) AS Begin Declare @KeepValues as varchar(50) Set @KeepValues=”%[^a-z]%” While PatIndex(@KeepValues, @Temp) > 0 Set @Temp = Stuff(@Temp, PatIndex(@KeepValues, @Temp), 1, ”) Return @Temp End Call it like this: Select dbo.RemoveNonAlphaCharacters(‘abc1234def5678ghi90jkl’) Once you understand the code, you should see that it is relatively simple to change it … Read more
In researching Matt’s comment, I have revised my original statement. He is correct, there will be a difference in performance between an inline table valued function (ITVF) and a multi-statement table valued function (MSTVF) even if they both simply execute a SELECT statement. SQL Server will treat an ITVF somewhat like a VIEW in that … Read more