Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 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
What do you understand by triggers and mention the different types of it?
How can I create a report based on a query? : sql server management studio
how to do partition in sqlserver
How to loop through result set objects using odbc_fetch_row()?
How to view the error log for any specific instance? : sql server database administration
How to write a query with a left outer join in ms sql server?
What are the 10 characteristics of data quality?
What are the new data types are introduced in sql 2000?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Which rendering formats are affected by the pagesize properties?
What are the advantages of stored procedure in sql server?
What to check if a User database is locked?
Explain the concept of view and Types of views in SQL server?
What is the meaning of sql server?
What is the difference between online clustering and Offline clustering?
