Member Avatar for ravi035

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

Edited by ravi035 because: n/a
  • 3 Contributors
  • 2 Replies
  • 69 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by prit005
Member Avatar for adam_k

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.

Member Avatar for prit005

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.