Dynamically building SQL Statment in SQL Server Stored Procs

[Auld Nick II]

I'm quite new to writing SQL server stored procs.

Normally in an asp page I would write build my SQL statement dyanamically, adding column names and value names depending on values that had been passed to the page.

In SQL server I can dynamically add the value using a parameter, but it would seem to be the case the column names have to be hard coded. Is this true, or is there a way that I can dynamically build the column list on the basis of the parameters passed to the procedure?

Cheers.

[Bonker Gudd]

In an SP, you can build your SQL in a string and then do EXEC(@string)

[Auld Nick II]

Bonker Gudd you are a gent and a scholar