Re: Stored Procedure Syntax

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Thu, 25 Nov 2004 23:25:12 -0800

Hi,

Thanks for your answer.
Actually I am writing a coding convention document for Microsoft SQL
server's Stored Procedure. I am just not very sure whether this will be
useful for the other SQL dialects like Oracle.

SK

"Val Mazur" wrote:

> Hi,
>
> There is no such thing as "other DBMS". Each database usually has its own
> dialect of SQL or its own syntax. You cannot compare them because it does
> not make any sense. If you are trying to write something generic, then it is
> not a good way to think, because you never know what difference and database
> could be. If you have more specific question, then maybe you should post it
> here and someone will try to answer it.
>
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "SK" <SK@discussions.microsoft.com> wrote in message
> news:70A8CF0A-2D76-470A-98E3-B589D9B70F6C@microsoft.com...
> > 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

  • sql server 2000 and stored proc returning cursor to perl
    ... I am trying to run a stored procedure in Microsoft SQL 2000. ... procedure is supposed to return a cursor back to perl. ... Do you think it might be sql server 2000 specific or there is a DBI code ...
    (perl.dbi.users)
  • Delphi 6 - Data type conversion error, please help
    ... I have a stored procedure object on a form I've created with Delphi 6. ... The stored procedure object uses SOAP to connect to a Microsoft SQL ...
    (comp.lang.pascal.delphi.misc)
  • Stored Procedure: Insert row and retrieve scalar value as a result.
    ... I would like to create a stored procedore in access 2003 database. ... it in one command as i am doing so with Microsoft SQL. ... i can not create and run that stored procedure while dealing ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: StoredProcedures
    ... > Anyone have an example with stored procedure with Microsoft SQL ... Herfried K. Wagner [MVP] ...
    (microsoft.public.dotnet.languages.vb)