Petri.co.il forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Databases > SQL Server Scripting / Automation
Petri.co.il is happy to award RicklesP the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read
Notices

SQL Trigger Help

SQL Trigger Help

this thread has 0 replies and has been viewed 13989 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 23rd November 2011, 23:47
mkaminski mkaminski is offline
Casual
Casual
 
 Join Date: Nov 2011
  6 month star 12 month star
 Location: New London, CT
 Posts: 3
 Reputation: mkaminski is on a distinguished road (10)
Default SQL Trigger Help

Hey Everyone,

I just need a quick check as I'm relatively rusty on SQL. I'm making a trigger that will run on an INSERT into Table A and copy that same data to Table B. What I have right now is:

CREATE TRIGGER table_copy
ON OldDatabase.dbo.OldTable
Insert
Begin
Insert INTO NewDB.dbo.NewTable
End
Go

A couple things I'm fuzzy on are whether this will stay in the system like a stored proc and general syntax verification. It's been far too many years since I've had to mess with SQL so I'm just making sure I'm still mostly correct.

Last edited by mkaminski; 23rd November 2011 at 23:53..
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger on event in folder Chrisdo PowerShell 5 11th April 2011 15:38
Group Policy Update Refresh Trigger boondock GPO 3 25th January 2011 20:50
E-Mail trigger from a cell in Excel mbridget1 Office 2007 General Issues 6 15th October 2010 22:31
local mail deliver trigger "start outbound tranfer" and get NDR report. jimmyjiang Exchange 2000 / 2003 1 15th September 2009 21:49


All times are GMT +3. The time now is 00:33.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri