how to create stored procedure for altering multiple coulmns ,
how to create stored for creating dynamic table and add multiple columns to created table

You will need to explain a bit your requests. By altering multiple columns, you mean update? Will the columns be fixed or are they to be passed as parameters (if this is the case, will the table also be a parameter?). Will the proc accept criteria as a value to a specific column or is it to be dynamic?

For the second part: What do you mean dynamic table?

Read here on how to create a stored procedure: http://msdn.microsoft.com/en-us/library/ms187926.aspx
and let us know if you have any problems.

create Procedure ProcedureName
-- declare variable
as
begin
your DML Statement
End
go

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.