#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    18
    Rep Power
    0

    Question create a table and insert values in one command?


    Hi I am trying to make a command to create a table and add constraints to a couple columns. That is fine but how can I add values to it in the same statement.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    USA
    Posts
    2
    Rep Power
    0
    Originally Posted by IronMaidenIrons
    Hi I am trying to make a command to create a table and add constraints to a couple columns. That is fine but how can I add values to it in the same statement.
    I dont think you can do it in one command, simplest suggestion would be to run a script that first creates the table then inserts.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    18
    Rep Power
    0
    thanks i figured that out. teacher is trying to play trick questions to see if we know the chapter

IMN logo majestic logo threadwatch logo seochat tools logo