create procedure create_table @table1 varchar(20) as Begin Declare @

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 / pradip jain

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

Answer Posted / pradip jain

create procedure create_table
@table1 varchar(20)
as
Begin

Declare @table table
(
id int,
name char(20)
)
end

If you refer question only syntax error is there!!! as table
variable can not use using create command.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can sql server instances be hidden?

924

What is the order in which the sql query is executed?

924

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

885

what is an index? : Sql server database administration

956

what purpose does the model database serve? : Sql server database administration

954

What is the purpose of a table?

942

Explain about merge replications?

995

Explain log shipping?

996

How to run sql server 2005 books online on your local system?

943

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1035

How to loop through the result set with @@fetch_status?

1311

Can We Use Data-grids For Our Report In Ssrs?

184

What happens if you are trying to access a schema not owned by you?

955

Explain external key management in sql server 2008

869

What xml support does the sql server extend?

987