Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    vizag
    Posts
    11

    Thumbs up Unanswered: Dynaically Creating From Stored Procedure

    hi

    can any one help me out abt this doubt

    "Accept a string into a stored procedures input parameter and create a table dynamically from the strored procedure. The name of the table thus created should be the same as the string value accepted into the parameter."

    so if any body can provide the necessary code will be great help ful or atleast how to advance

    thankyou
    kalyan sekhar

  2. #2
    Join Date
    Nov 2002
    Posts
    14

    Re: Dynaically Creating From Stored Procedure

    -- @tableName is the param

    exec 'create table ' + @tableName + ' ( your_column_definitions ) and_optionally_constraints';
    Zlatko Michailov
    Z-SQL

Posting Permissions

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