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
- 7038 Views
- Aptech, I also Faced
- E-Mail Answers
Answer Posted / monty
hello Saravanan Sankar
thank you for your answer
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List out some of the requirements to set up a sql server failover cluster?
How many triggers are possible per table?
Explain query editor regions
How to create prepared statements using odbc_prepare()?
What are the extra roles available in msdb? : sql server security
Do you know what is difference between stored procedure and user defined function?
What are clustered and non-clustered index?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What are the tables in sql?
Does group by or order by come first?
How to trouble shoot if unable to connect SQL Server
How does the report manager work in SSRS?
How to execute a stored procedure in ms sql server?
What are different types of statements that are supported by sql?
Define outer join?
