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?
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 is the sql profiler?
What are the different acid properties?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is the difference between grant and with grant while giving permissions to the user?
Can we use where and having clause together?
Can binary strings be converted into numeric or float data types?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What do you understand by the analysis services in sql server?
Is foreign key a primary key?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Explain for xml explicit mode?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What are the recovery models for a database?
Can you explain different types of locks in sql server?
how many no of arguments can be passed in procedures and functions