Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!



> I saw in the
> sql help that it states that stored procedures don't return values??? But
> then I see that there is the 'return' ?call? available that is suppose to
> return a value...???
In MS-SQL, you call RETURN() to send a return value. (Right before the GO)


.



Relevant Pages

  • Re: SQL Statement in C#
    ... This is mainly MS-SQL thinking, with other databases ... they do not think this way dynamic SQL is the prime method. ... people who have a problem with stored procedures have it with CRUD ... statements, if you are doing something that multiple database pulls, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: On sysprocplan being locked
    ... if the modified temp tables are used by stored procedures and they have ... as will changing user permisions on the table ... Prev by Date: ...
    (comp.databases.informix)
  • Stored Procedure
    ... Are stored procedures are precompiled in SQL Server. ... John. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How do i search all Stored Procedures for a table name
    ... Select object_nameFrom syscomments where text like ... > What I want to do is to search within the text of all Stored Procedures ... > Would I use sysobjects? ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • How do I change a field name from vb code?
    ... I have a database with many tables which have field names including the ... MSSQL and this kind of field name is not accepted in stored procedures. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)