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
7816 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

What is the difference between substr and charindex in the sql server?

998

What to perform pattern match with the like operator?

836

What is checkpoint in sql server?

1056

Explain what are the restrictions that views have to follow? : SQL Server Architecture

986

Explain cdc and sql injection?

909

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

927

Tell about MOM Tool(Microsoft Operator Manager)?

1852

What is partition in sql server?

972

What will be the maximum number of index per table?

947

How to write an inner join with the where clause in ms sql server?

1026

What are security principals used in sql server 2005?

901

What is the difference RDBMS and Graph Database?

1003

How do I start and stop sql server?

963

What are the recovery models in sql server 2000?

925

Explain DBCC?

907