Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-18 : 09:29:50
|
Tom writes "I want to be able to pass a variable for the table name. I know I can do it
because if I do it in the asp page it works fine.
Conn.Execute "CREATE TABLE branch " & test & " ( branch_id uniqueidentifier
not null, branch_number int not null, branch_inventory char null)"
but for some reason it's not working in a stored procedure
CREATE PROCEDURE sp_newbranch
@number AS INT
AS
BEGIN
CREATE TABLE @number
(
branch_id uniqueidentifier not null ,
branch_number int not null ,
branch_inventory char null
)
END
GO
Any Ideas?
Thanks,
Tom Tiveron" |
|
|
|
|
|
Passing A Variable to the CREATE TABLE Procedure