datatype to store column name - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

datatype to store column name

Author

Topic

karthick.amace
Starting Member

23 Posts

Posted - 2010-07-23 : 22:12:47

Hi brothers
I want to know the datatype which is used to store the column name of table. Because I want to use that column name in my Update statement
Plz help me and suggest me to do..

sample
Declare @colname ?????
Set @colname=(SELECT c.name FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE t.name='Acomp' and c.name=1)

Update Acomp
Set @colname=5
Where empid=101

my column will be like numbers eg.,[1],[2],[3]...
wherevr my input values and colname mayches I want to update the value
this is the requirement

I tried this,
unfortunately is not worked
DECLARE @temp sysname
SET @temp=(SELECT c.name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE t.name='Acomp' and c.name=1)

update AComp
set @temp=5
where empid=101

I thnk it taking @temp as some temp variable not as column...

Plz let me know is that possible...?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-07-23 : 22:59:12

Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=147733

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources