Re: SQL-Batch mit Transaktion ausführen/abbrechen

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Frank Kalis (nospam_at_insidesql.de)
Date: 07/15/04 

Date: Thu, 15 Jul 2004 06:27:01 -0700

Schau mal in Dein SQL Server /Install Verzeichnis. Vielleicht bringt das Stöbern dort auf Ideen. 

-- 
--Frank
http://www.insidesql.de
"Stefan Dase" wrote:
> Hallo Frank!
> 
> > SQL Server MVP Erland Sommarskog hat auf seiner Seite
>  > http://www.sommarskog.se zwei Artikel über Fehlerbehandlung
>  > in T-SQL, die dich weiterbringen werden.
> 
> Leider beschreibt der Autor nur die Behandlung in einer Stored 
> Procedure, d.h. in einem Batch. Was mich interessiert ist die 
> Möglichkeit, dies in einem kompletten Scipt durchführen zu können, und 
> gerade dass schließt Erland aus: "[...] and I disregard administrative 
> scripts like scripts for backup or scripts that create or change tables 
> [...]". :-(
> 
> Trotzdem danke für den Hinweis, das Hintergrundwissen kann ja nicht 
> schaden. :)
> 
> Viele Grüße,
> Stefan
>

Relevant Pages

  • Re: getdate() in UDF
    ... Or it is classified as imprecise rather than non-deterministic? ... return from Erland) ... > Here noofyears is a computed column which tells us how long a person ... > SQL Server must materialize the values. ...
    (microsoft.public.sqlserver.programming)
  • Re: more than 8192 characters in text file output
    ... Thanks Erland. ... results that are "export as grid" you can't choose the delimiter. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.programming)
  • Re: stored procedure question
    ... Erland, ... regarding computing and large insert be done directly in the database. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Syntax coloring: SERVICE
    ... If so, Erland, it is only because I have failed in my attempts to ... any version of Outlook. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: a simple sql question
    ... I can confirm Erland. ... I wrote a course for 6.5 and distinctively remember that ANSI joins were new. ... They didn't re-write BOL for 6.5, they just added a "What's new in SQL Server 6.5" section. ... · CROSS JOIN ...
    (microsoft.public.sqlserver.programming)