Creating New Table fromTriggers

Results 1 to 3 of 3

Thread: Creating New Table fromTriggers

  1. #1
    Join Date
    Dec 1969

    Default Creating New Table fromTriggers

    I want to run a trigger so that i can create a new table from it, can it be done by any means

  2. #2
    Darren Neimke Guest

    Default RE: Creating New Table fromTriggers

    1. Right Click on the Table that you want to create the Trigger on.<BR>2. Choose "All Tasks" from the menu.<BR>3. Choose "Manage Triggers".<BR><BR>You now have the option of adding a Trigger related to either an INSERT, UPDATE or DELETE event. Here is some sample code for adding a Trigger on the INSERT event:<BR><BR><BR><BR>CREATE TRIGGER tr_Insert ON [dbo].[Authors] <BR>FOR INSERT<BR>AS<BR><BR>CREATE TABLE Blah<BR>(<BR> fldOne int,<BR> fldTwo varchar(50),<BR> fldThree datetime default null<BR>)<BR><BR>HTH<BR>Darren <BR>[ ]

  3. #3
    Join Date
    Dec 1969

    Default Thanks a lot

    Thanks a lot Mr. Darren, my problem got solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts