Re: CLR-Trigger und temp tables

Am 9 May 2006 12:22:28 -0700 schrieb Jens:


mal ganz minimalitisch betrachtet, brauchst Du nur notepad.exe zu
schreiben and csc.exe zum kompilieren wenn Du ein C# / CLR Codeteil
für den SQL Server schreiben willst, jeden weitere Extra an grafischer
Oberfläche hilft da natürlich weiter :-)

Das ist zwar wirklich minimalistisch, würde mir aber gar nicht so schlecht
gefallen, da Trigger ja sowieso keine GUI haben.
Meine Frage basiert auf dem Community-Webcast zum SQL Server 2005, wo sowas
zusammen mit dem VisualStudio so schön dargestellt wird, allerdings habe
ich keine Ahnung, was durch das "SQL Server Project" alles im Hintergrund
abläuft. Aber das muss ich ja sowieso lernen, ich kann ja nicht beim Kunden
ein VS installieren, weil ich sonst den Trigger nicht installieren kann.

servus, Helmut
.

Relevant Pages

  • Re: Records not inserting...
    ... > I am totally new to SQL server. ... However, in a trigger, would I be ... test the effects of certain data modifications and to set conditions for ... UPDATE statements. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ...
    (comp.databases.oracle.server)
  • Re: TRIGGER (AFTER INSERT) and Store Procedure ... insert failed !
    ... >into SQL server, the record exist anyway! ... >If you refresh the data you will see the record... ... it gets refreshed after trigger excecution automatically. ... I don't know your monitoring system, but I guess that removing the result ...
    (microsoft.public.sqlserver.programming)
  • Re: Access Bug with SQL Server identity columns
    ... Even though SQL Server since version 2000 has had a reliable ... The work-around I've always used is to make sure that no trigger inserts into ... a table that contains an IDENTITY column, and use some other unique identifier ... >create a form on table1 with a subform on table2. ...
    (comp.databases.ms-access)
  • Re: Help for an Oracle Newbie
    ... application I wrote using SQL Server ported over to Oracle. ... Obviously there are several built in data types in SQL Server that do ... Of course I had to use a different name for the trigger under each ... In SQL Server I always create a CreatedDate column ...
    (comp.databases.oracle.server)