Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Column Names as Paramaters

Author  Topic 

Brittney10
Posting Yak Master

154 Posts

Posted - 2011-01-24 : 14:40:04
How can I pass column names as parameters when the column names in SQL have spaces? For example @[Column Name]??? Is there a certain way to encapsulate this? I'm coding in Visual Basic.NET and C#. Thanks.

dataguru1971
Master Smack Fu Yak Hacker

1464 Posts

Posted - 2011-01-24 : 14:57:50
You would pass the parameter as a string including the brackets. '[Column Name]'. Presuming the parameter actually accepts a column name, the brackets would be required as part of the string.



Poor planning on your part does not constitute an emergency on my part.
Go to Top of Page
   

- Advertisement -