Post reply

create table

  • November 8, 2012 at 11:10 am

    #266834

    Hello

    I need help for one task

    I need to create trigger on table called [tblUserSchools] for one user = 795

    so if user = 795 insert,update and delete something

    we need to copy into one table,

    the information we looking is date , type(insert,update,delete), sql account

    so please help me to create trigger

    Thanks

  • November 8, 2012 at 12:04 pm

    #1557324

    Use Google to find information on "sql server instead of trigger". I don't think anyone will write a trigger for you (especially given the lack of info you've supplied) when you can look it up quite easily.

    I'm not clear on whether or not the user id is a value that is part of the insert. If it is, use logic (if statements) to do one thing if it meets the criteria you're looking for and whatever else if not. If that info is not part of the data being inserted/updated/deleted you can use the function suser_name() to get the active login.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply