How do I pass columns/table names as parameters?

[ajax.sam]

hi all, i got 2 questions! i want to do these:

1. select @col1 from some_table where <some_conditions>; I can pass
parameters by using Parameters.Add for <some_conditions> but not for
the @col1. How do i do that? How do i pass column names as parameters?

2. select * from @table; How can i pass a table name as a parameter?

Thanks,

 

[Ciaran O''Donnell]

You can generate the full statement in C# and run it against the database
server, or generate the sql in the sp and all spexecute_sql and pass the sql
as an NVARCHAR