Stored Procedure Syntax

From: SK (SK_at_discussions.microsoft.com)
Date: 11/24/04 

Date: Tue, 23 Nov 2004 19:41:05 -0800

May I know is the syntax for the stored procedure in Microsoft SQL server the
same as the other DBMS?

If no, is the difference huge?

Thanks in advance.

Relevant Pages

  • Re: chooses not to generate code at all
    ... >>>DBMS is so that the DBMS engine can execute it when triggered by some ... If there is no trigger, ... Stored procedure is one thing. ... > If the procedure execution is not triggered by DBMS ...
    (comp.object)
  • Re: Is there a way to syntax check all stored procedures (without deferred name resolution)
    ... You can check the syntax of a stored procedure in Query Analyzer by ... The drawback is that this will not work if your stored procedure uses ... You can't disable Deferred Name Resolution. ... > tables, changing column names, removing columns, etc. ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL transaction rollback problem
    ... I'm not a C++ programmer so can't help you with the syntax, ... close the connection so that it is returned to the pool. ... tell as to how to call the stored procedure from a C++ program. ... You can pass it input parameters and retrieve ...
    (microsoft.public.data.odbc)
  • Re: Little Lock Symbols
    ... will see that means "parse" (syntax check). ... The success message means that ... No, from your earlier description, this is a stored procedure in a database. ...
    (microsoft.public.sqlserver.tools)
  • Re: chooses not to generate code at all
    ... >The whole point of having a stored procedure as an integral part of the ... >DBMS is so that the DBMS engine can execute it when triggered by some ... Nor is a conventional RDB the only way to ... >problem space. ...
    (comp.object)