Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    5

    Question Unanswered: Dynamic Create Table in Stored Procedure

    Hi,
    Sorry, I know this is a very easy question.
    I as a amature SQL learner because of my college project have to create a stored procedure in a SQL SERVER Database with this condition :
    -get Columns and datatypes as parameters like this :
    col1,datatupe1,col2,datatype2,....
    -create table with this properties ... .
    I have some problem about syntax.
    I would appreciate your help.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Why don't you cut and paste the assignment as is so we can all see it.

    Better yet, why don't you go to a lab and ask for help?

    I find it very hard to believe that the assignment is to build objects dynamically.

    What school did you say this was?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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