Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optional Parameters in Functions
- Thread starter Shaggs
- Start date
Optional" parameters?... not really, but you can set up default values for your parameters, but you have to pass them as 'DEFAULT' to the function:
[tt]
CREATE FUNCTION myFunction(@param INT = 1) RETURNS INT
AS
BEGIN
RETURN @param
END
GO
SELECT dbo.myFunction(DEFAULT)
UNION
SELECT dbo.myFunction(5)
GO
DROP FUNCTION myFunction
[/tt]
-dave
[tt]
CREATE FUNCTION myFunction(@param INT = 1) RETURNS INT
AS
BEGIN
RETURN @param
END
GO
SELECT dbo.myFunction(DEFAULT)
UNION
SELECT dbo.myFunction(5)
GO
DROP FUNCTION myFunction
[/tt]
-dave
- Status
Similar threads
- Locked
- Question
- Locked
- Question