Re: Error Handling Coming Out of a Trigger

Brian,

You can write an awful lot of code in a stored proc but guess what .... they
dont want to compile the program ??? stored procedures are compiled so
what's the difference ??? And with programs you get version control so you
can go back in case of a major whoops .. doing so on sql server is not
"simple" .. try restoring a stored proc .. I am pretty sure you have to put
the DB in single user mode first (never been able to get it to work
otherwise .. but then , I'm not a DBA) and that means everyone, the whole
hospital gets off the system.

SQL Server 2005 will let you write VB in the stored proc and it does a
pretty good job of optimizing it so you can do about anything you want. Of
course you will have to compile it .. dont tell the bosses, they will want
to do the whole system in Javascript in a browser , that wont have to be
compiled ... just interpreted .. you know, like back in the old original
Basic days ... LMAO ....


I'm not trying to sway you to do it like I do it, I just like pointing out
some of the dumb stuff "managers" come up with ...
not compiling the program .... jeez. How long does a Delphi compile take ...
3 secs, 5 maybe ???

You can do the join to the rules, derive a temptable, run back and forth
over the cursor etc in the stored proc once you get used to the syntax.

Good luck,'

Del





.

Relevant Pages

  • Re: free SDK for ipaq h63xx?
    ... And the OPA is much more powersaving! ... Dont think anyone here in MS-Forums will point you to a Linux-Device (they ... compile for all these processors? ... - integrated WLAN ...
    (microsoft.public.pocketpc.developer)
  • Re: Help with SQL 2005 and Sourcesafe 6
    ... That doesn't seem to be the case with stored procedures. ... compile that latest version to be table to use it. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • The VBA project in the database is corrup
    ... I have an access 2003 database connected to sql server. ... I have finished some modifications and used access workbench to compile it ... as mde. ...
    (microsoft.public.access.security)
  • The VBA project in the database is corrupt
    ... I have an access 2003 database connected to sql server. ... I have finished some modifications and used access workbench to compile it ... as mde. ...
    (microsoft.public.access.devtoolkits)
  • Re: Avoiding floating points
    ... Interbase dialect 1, and so all my fields are of course converted to ... Compile it once, and it works, compile ... FirebirdSQL and MS SQL Server! ... CopyTiger - the ultimate database replication solution for CodeGear ...
    (borland.public.delphi.non-technical)