October 12, 2005 at 7:55 pm
TWO HARD QUESTIONS FOR YOU! (aren't you so excited?)
I need to know how to create a PROCEDURE that will output the mean and standard deviation of a table, which I created with the name Account, and then output the results to me.
Second, this is the harder one, I need to create a table named ActionHistory consisting of two columns, TableName and ActionTime, then create a TRIGGER that will write the name of the previous table "Account" into the TableName portion, and the time of the change/update into the ActionHistory portion, whenever there is a change/update made to the Account table. To sort of keep track of all the action made to the Account table, so if someone were to manipulate it, we'd know which table (I will be creating this for multiple tables) as well as WHEN (datetime).
PLEASE HELP!!!!! And btw, I use Microsoft SQL 2000
THANKS.
- Rani
October 12, 2005 at 10:04 pm
Please don't cross-post. Most people look at numerous locations on this site.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=228528&post=true
I wasn't born stupid - I had to study.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply