IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME = 'PROCEDURENAME

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 / patan

5 Answers
8048 Views
Aptech, I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

How to connect to SQL Azure Database by using sqlcmd?

136

how many type of indexing in database?

985

How to download and install sql server 2005 books online?

1195

How do I port a number to sql server?

1046

What is the definition for sql server 2000?

1096

Write an sql query for deleting duplicate rows?

1002

Can we write a distributed query and get some data which is located on other server and oracle database?

1234

Explain following error properties?

1023

What is shared lock?

907

What is TDS(Tabular Data Stream) Gateway?

121

what is a transaction? : Sql server database administration

997

What does COMMIT command do?

1069

Explain identity in sql server?

1016

Does index speed up select statements?

1017

What is dimension table? : sql server analysis services, ssas

1024