Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 RETURN statement. what's this?

Author  Topic 

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-05-06 : 00:58:26
Sometimes, I saw T-SQL using RETURN.

What's this? Does it mean STOP and no process the next

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-05-06 : 06:42:14
Yes.

RETRUN statement exits unconditionally from a query or procedure (and returns to the calling program/code): http://msdn.microsoft.com/en-us/library/ms174998.aspx

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-05-06 : 13:27:14
quote:
Originally posted by wkm1925

Sometimes, I saw T-SQL using RETURN.

What's this? Does it mean STOP and no process the next


that should mostly inside UDFs or SPs to return control to calling code with return values if any

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -