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?
- 5 Answers
- 7035 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
What is 2nf normalization form?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Can you please differentiate between a primary key and a unique key?
What is nolock?
What is the osql utility?
Can binary strings be converted into numeric or float data types?
Is sql server implemented as a service or an application? : Sql server database administration
What are different types of subquery?
How to insert data into an existing table?
Do you have any idea about the tcl commands?
Explain magic tables in sql server?
Explain features and concepts of analysis services?
How will you hide an attribute? : sql server analysis services, ssas
what is blocking? : Sql server database administration
What is outer join in sql server joins?
