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?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
Explain the microsoft sql server delete command? : SQL Server Architecture
What is data source document?
Explain about system stored procedure?
Write a program using SQL queries to find a unique entry in a table.
What is a trigger and types of a trigger?
Can you pass expressions to stored procedure parameters?
How do I create a stored procedure in sql server?
What are different types of subquery?
What is #table in sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
Define constraints and give an example of their use?
Does partitioning ssd reduce performance?