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
8047 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 do you understand by triggers and mention the different types of it?

950

How can I create a report based on a query? : sql server management studio

1022

how to do partition in sqlserver

2481

How to loop through result set objects using odbc_fetch_row()?

984

How to view the error log for any specific instance? : sql server database administration

1045

How to write a query with a left outer join in ms sql server?

987

What are the 10 characteristics of data quality?

956

What are the new data types are introduced in sql 2000?

908

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2227

Which rendering formats are affected by the pagesize properties?

144

What are the advantages of stored procedure in sql server?

896

What to check if a User database is locked?

1074

Explain the concept of view and Types of views in SQL server?

995

What is the meaning of sql server?

986

What is the difference between online clustering and Offline clustering?

2419