Loading

Difference between returns and return in sqlserver function

Difference between returns and return in sqlserver function

Rajveer singh

Rajveer singh

11y9.4k

main Difference between returns and return ? what use this keyword give one example ...........

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhinav Pal11y ago
Accepted answer
RETURN and RETURNS have different scope in t-sql.
RETURN can be used any where in t-sql.It will immediately stop the execution from the point where RETURN keyword is found and will not execute further lines of t-sql code. Additionally RETURN keyword can also return some value out from the procedure stopping the execution from there.
RETURNS is limited to scalar and table valued functions defining the return type information. Like below

CREATE FUNCTION xyz(@minId int) -- input parameter
RETURNS @tableXYZ TABLE (
Id int NOT NULL,
Modified datetime NULL
)
AS
BEGIN
Insert into @tableXYZ
Select 1, getdate ()
RETURN;
END

Hope this will useful to you
Priyaranjan K S11y ago
Rajveer,

Return Exits unconditionally from a query or procedure. There is no 'returns' Keyword. The following example shows if no user name(@nm) is specified as a parameter when findjobs is executed, RETURNcauses the procedure to exit after a message has been sent to the user's screen. If a user name is specified, the names of all objects created by this user in the current database are retrieved from the appropriate system tables

CREATE PROCEDURE findjobs @nm sysname = NULL
AS
IF @nm IS NULL
BEGIN
PRINT 'You must give a user name'
RETURN
END
ELSE
BEGIN
SELECT o.name, o.id, o.uid
FROM sysobjects o INNER JOIN master..syslogins l
ON o.uid = l.sid
WHERE l.name = @nm
END;

Thanks,
Priyan

If you found this useful Please Accept this as Answer