Return and returns

Question

what is the difference between return and returns keyword in sql ?

Vulpes · Answer

In SQL Server keywords are not case sensitive though personally I like to write them in upper case so they stand out from the rest of the code.

Sam Hobbs · Answer

Sorry I got caught by the problem that all forums are lumped together in the forum home page. So I assumed that this question is a C# question not a SQL Server question.

Sam Hobbs · Answer

There is return in C# but I have not heard of RETURN.

Vulpes · Answer

Well the RETURN keyword causes an immediate exit from a query or stored procedure. According to this link: http://msdn.microsoft.com/en-us/library/ms189822.aspx the RETURNS keyword is reserved for future use and so does nothing at present.