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 2000 Forums
 SQL Server Development (2000)
 Using a variable for a Field name in a Stored Proc

Author  Topic 

Cyclonik
Posting Yak Master

114 Posts

Posted - 2000-11-27 : 16:00:54
How can i use a variable for a field name in a Stored Procedure (SQL Server 6.5)?

This doesn't work
SELECT @GroupCheck=@Group From tblGroups Where Lanid=@LanId

the @Group is passed into the stored proc..
i hope there is some way to do this.

Thanks
Christian

PS. What is this Books Online i see everyone referring to?

-=:SpasmatiK:=-

Edited by - Cyclonik on 11/27/2000 16:03:04
   

- Advertisement -