Re: Suggestoins for Local DB to use with Shareware

I.P. Nichols wrote:

I've long ago rejected that argument, if on no other basis than on non
standard support for stored procedures,

Stored procs and triggers are another issue altogether, and every product
has their own internal language and features there. This also applies to
unique value facilities - generators in InterBase/Firebird, Sequences in
Oracle, @Identity in MS SQL, etc.

But the bulk of any database application is going to be the SQL it needs to
use.

--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"Light is faster than sound, which is why some folks appear bright
before they speak."


.

Relevant Pages

  • Re: COBOL/DB2 Date edit question
    ... Stored procedures are becoming a way of life on many sites, ... Banging away at databases with primitive SQL is ... Within all of this a lot of validation has been going on. ... and submit them together to an UPDATE that triggers the cross validation. ...
    (comp.lang.cobol)
  • Re: Pass-thru SQL performance vs Stored Proc
    ... > pass-thru) SQL helps. ... Right now all our code is in stored procs. ... In general, always use stored procedures. ... > I thought I read somewhere that SQL-Server will cache in-line SQL calls ...
    (microsoft.public.sqlserver.programming)
  • Re: Advatages of Stored Procedures?
    ... stored procedures, you have to know the good and bad. ... stored procs are retained in the procedure cache and the SQL ... Maintenance, as your application ages and needs changed, some stored procs ...
    (microsoft.public.dotnet.framework.adonet)
  • Encrypting SQL objects
    ... I have a question regarding putting secuirty on sql server 2005 ... objects, i.e. Stored procs, Views, triggers. ...
    (microsoft.public.sqlserver.security)
  • Re: Keeping ROWNUM across two SELECT statements
    ... SQL> create sequence my_sequence; ... SQL> select my_sequence.currval from dual; ... > SEQUENCE that way, but as I say, I'm not allowed to use triggers. ... use triggers and stored procedures to management. ...
    (comp.databases.oracle.misc)
Loading