Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transact-SQL CREATE TABLE

 
Jimmy Clark
Ranch Hand
Posts: 2187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
With a stored procedure, I want to create a table when a user registers with the application. I want to use an argument passed in the stored procedure call as part of the table name.

Example:

createUserTable '1987';

So, the CREATE statement would look like:

CREATE TABLE [dbo].[@arg_expense_record]

...

This should create a new table named: 1987_expense_record

I haven't figure out if this is possible. I keep creating a table with the @arg string in the table name instead of the value. I'm not sure if this can be done with the CREATE TABLE command in Transact-SQL.

Any help is greatly appreciated.

Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic