SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    May 2009
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Stored procedure or trigger?

    Hello!
    My databse will contain a survay. I Have one table to store the mail questions, there is 4 different kine of questions depending on the answer format. Therefor I have 4 more tables to store those questions. How should I move th dta between the ables, with triggers or stored procedures?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,273
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    move the data? whatever for? just store it in the correct table to start with

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    May 2009
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Oh Im getting crazy! I dont think that I understand my self the construktin of the database.

    One question has different type of answers. Thats why Im confiused....I dont know how to store the questions and te answers..


Bookmarks

Posting Permissions

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