Value from Query

• Ashok-148808

  SSC Veteran

  Points: 217

  More actions

  September 28, 2006 at 1:44 am

  #153206

  Compare both

  declare @test-2 varchar(10)

  declare @field varchar(10)

  SET @field = 'CustomerID'

  Select @test-2 = @field from Customers WHERE     (City = 'Berlin')

  Print @test-2

  this prints CustomerID (the field Name as such) Instead ALFKI.

  ---------------------------------

  SELECT     CustomerID FROM         Customers WHERE     (City = 'Berlin')

   

  here my result is ALFKI.

  I need the Same in the above.

   

  Help Me.

• Prasad Bhogadi

  SSCrazy Eights

  Points: 9235

  More actions

  September 28, 2006 at 2:06 am

  #662926

  CREATE PROCEDURE MyProc

  @Field VARCHAR(50)

  AS

  DECLARE @StrQry VARCHAR(1000)

  SET @StrQry = 'SELECT ' + @Field + ' FROM Customers WHERE     (City = ''Berlin'')'

  EXEC (@StrQry)

  GO

  EXEC MyProc 'CustomerID'

  GO

  Prasad Bhogadi
  www.inforaise.com