Re: Stored Procedure Syntax

From: Val Mazur (group51a_at_hotmail.com)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 18:45:20 -0500

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

  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >>> Are you sure that a column in Pick is equivalent to a column in an SQL ... > You can also change the type from varchar to array if your SQL DBMS support ... > for variables that store the data retrieved from the database. ... >>> SQL is not the only language. ...
    (comp.databases.theory)
  • Re: MV and SQL
    ... >> perform enquiries on it using the query language then, again, how the ... > Are you sure that a column in Pick is equivalent to a column in an SQL table ... If you had some bizarre need to do this in a Pick DBMS though, ... > Besides the query language of Pick what other ways do ...
    (comp.databases.theory)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.databases)