SQL Server's Journal (original) (raw)

SQL Server's Journal > recent entries > calendar > friends > microsoft.com/sql > profile	Monday, July 26th, 2004 11:18a - User-defined functions Anyone have experience with user-defined functions? I'm trying to write one that takes two parameters; it returns the first one if it's not NULL, otherwise it returns the second one. like this:CREATE FUNCTION loginName.functionName (@val1 int, @val2 int) RETURNS (int) AS BEGIN (FUNCTION BODY) ENDI don't know what to put in "(FUNCTION BODY)". Anyone? (8 comments \|comment on this) << previous day [calendar] next day >>
> top of page
LiveJournal.com

SQL Server's Journal > recent entries > calendar > friends > microsoft.com/sql > profile

Monday, July 26th, 2004 11:18a - User-defined functions Anyone have experience with user-defined functions? I'm trying to write one that takes two parameters; it returns the first one if it's not NULL, otherwise it returns the second one. like this:CREATE FUNCTION loginName.functionName (@val1 int, @val2 int) RETURNS (int) AS BEGIN (FUNCTION BODY) ENDI don't know what to put in "(FUNCTION BODY)". Anyone? (8 comments |comment on this) << previous day [calendar] next day >>

> top of page

LiveJournal.com