Answer / saravanan sankar

CREATE PROCEDURE create_table
@table varchar(20)
AS
BEGIN
declare @string varchar(5000)
set @string = 'CREATE TABLE '+ @table +'(id int,name char(20))'
END
exec(@string)


//FIRST RUN PROCEDURE ABOVE AND THEN EXECUTES
EXEC create_table 'TABLE1'

Answer / 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.

Answer / monty

hello Saravanan Sankar
thank you for your answer

Answer / veeresh kethari

Here is the solution...

create proc CREATE_TABLE
@TableName varchar(50)
as
begin
declare @String nvarchar(max)
set @String='create table '+@TableName +'(ID int,Name
varchar(50))'
execute sp_executesql @String
end

Answer / patan

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = 'PROCEDURENAME')
DROP PROCEDURE PROCEDURENAME
GO
CREATE PROCEDURE PROCEDURENAME
@TEST INT = 0

AS
BEGIN
--HERE CREATING TABLE
DECLARE @CREATE TABLE (ID INT ,NAME VARCHAR(20))

INSERT INTO @CREATE VALUES (1,'PATAN')
.
.
.
.
.
.
END

IN PROCEDURE WE CAN CREATE TABLE AND IT CAN USE THE OUR PROCEDURE @CREATE IS THE TABLE NAME

NOTE:WHILE RUNNING TIME WE CAN CREATE TABLE WITH THERE ALIES NAMES...

THANKS @ GOOD LUCK

What is logshipping and its purpose?

0 Answers  

write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,

What are the steps you must follow to hide sql server instances?

0 Answers  

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

what is the diffrence between Snap Shot and Transaction Replication

2 Answers   CSC,

What gets stored inside msdb database?

0 Answers   Abacus,

What are the methods used to protect against sql injection attack?

0 Answers  

How do I start sql server agent automatically?

0 Answers  

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

0 Answers  

Explain relational data?

0 Answers