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

Explain index in sql server?

1006

How do use Having,Group by,Group function in SQL?

1733

on line cluster can we make if yes tell me the procedure

2012

Can you explain about buffer cash and log cache in sql server?

941

What is the difference between functions and stored procedures?

1151

what is dbcc? : Sql server database administration

1021

What is cursors? And what are the different types of cursor?

1135

How you would rewrite the sql query to return the customerid sorted numerically?

982

In which tcp/ip port does sql server run? Can it be changed?

982

How to change server name in sql server?

1173

Can a database be shrunk to 0 bytes, if not, why?

1090

What is t-sql script to take database offline – take database online.

1072

What is subreport?

141

What is the purpose of the tempdb database?

991

What is the contrast amongst drop and truncate?

1030