CREATE PROCEDURE create_table @table varchar(20) AS BEGIN declare @str

i want to create procedure for create table in sql server
2005

for example

create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?

Question Posted / saravanan sankar

5 Answers
8031 Views
Aptech, I also Faced
E-Mail Answers

Answer Posted / saravanan sankar

CREATE PROCEDURE create_table
@table varchar(20)
AS
BEGIN
declare @string varchar(5000)
set @string = 'CREATE TABLE '+ @table +'(id int,name char(20))'
END
exec(@string)

//FIRST RUN PROCEDURE ABOVE AND THEN EXECUTES
EXEC create_table 'TABLE1'

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is Federation and Federation Member?

Explain what is the difference between a local and a global temporary table?

1001

Can sub report data source be different from that of the parent report?

143

What do you mean by SQL injection attack?

1066

What is NOT NULL Constraint in sql server 2012?

1000

Define inner join in sql server joins?

1058

Do you know what are the properties of the relational tables?

1031

What are the properties of the relational tables?

881

What is data compression? : sql server database administration

969

What is self contained sub query?

1054

Write an sql query for deleting duplicate rows?

995

What’s the distinction between dropping a info and taking a info offline?

1038

Do you know what is replace and stuff function in sql server?

1010

List the various tools available for performance tuning?

887

Find first and last day of current month in sql server

1028