This week's book giveaway is in the OCAJP forum. We're giving away four copies of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) and have Khalid A Mughal & Rolf W Rasmussen on-line! See this thread for details.
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.
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.