Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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?

Question Posted / monty

Answers were Sorted based on User's Feedback



i want to create procedure for create table in sql server 2005 for example create procedure ..

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'

Is This Answer Correct ?    8 Yes 1 No

i want to create procedure for create table in sql server 2005 for example create procedure ..

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.

Is This Answer Correct ?    2 Yes 0 No

i want to create procedure for create table in sql server 2005 for example create procedure ..

Answer / monty

hello Saravanan Sankar
thank you for your answer

Is This Answer Correct ?    1 Yes 0 No

i want to create procedure for create table in sql server 2005 for example create procedure ..

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

Is This Answer Correct ?    1 Yes 0 No

i want to create procedure for create table in sql server 2005 for example create procedure ..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to find the date and time of last updated table?

3 Answers  

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

What are different types of Keys? Please explain all the keys with a suitable example.

4 Answers  

What is extent? Types of extents?

0 Answers  

Write a sql query to delete duplicate records from a table called table1

0 Answers  




can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

What are sql server functions?

0 Answers  

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

What is nested transaction?

0 Answers  

Describe the left outer join & right outer join. : sql server database administration

0 Answers  

How to make a column nullable?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories