0
Answer

Add Columns with ADO.Net parameters

Ask a question

Hi guys,

Due to previous poor database design, I need to maintain the columns of a table using ADO. I'd like to execute an anonymous procedure to do this, parameterising the column name to add.

Is it possible?

DECLARE @pLang Name
ALTER TABLE Languages
ADD @pLang varchar(254)

1 attempt above, this gives the error "Incorrect syntax near '@pLang'" but I think it gives an idea of what I want to achieve.

Any help greatly appreciated...