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
- 6356 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
What guidelines should be followed to help minimize deadlocks?
How to create dbo table in sql server?
What is replication with database mirroring? : sql server database administration
Explain the etl (extraction, transformation, and loading)?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are translations and its use? : sql server analysis services, ssas
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What happens when converting big values to integers?
What is nested transaction?
What do you understand by physical_only option in dbcc checkdb?
What are acid properties of transaction?
How to drop existing indexes in ms sql server?
What is self contained scalar sub query?
What is federation member?
What are sql server procedures?
