Creating the Columns in the table dynamically using SP

ketan borsdiya10y ago

Hi Hari,

Use below procedure,

CREATE PROCEDURE PRC_AddColumn

@tbaleName as varchar(50),

@ColumnName as varchar(50)

AS

Begin

Declare @str as nvarchar(200)

SET @str=N'ALTER TABLE ' + @tbaleName + '

ADD '+@ColumnName+' int NOT NULL DEFAULT(1)'

EXECUTE sp_executesql @str

END

0

Nitin Sontakke10y ago

Hello,

Looks like a very strange requirement to me. How often do you really have to do this.

It would be nice if you could give bit more back-ground information, as it might just change the whole approach.

0

Raja T10y ago

hi hari, u need add columns in existing table by using sp in dynamicall righ...?

so u know what the columns names or not ? if yes/no means it can easy ...

when you calling SP with parameter table name and if you know what are the columns means send again another parameter

like fieldname...so u can write code likeas

begin

alter table 'tablename'
add 'columnname1' varchar size 100
add 'columnname2' varchar size 100
add 'columnname3' varchar size 100

end

0