returning sysname data

• ekasenna

  SSC Enthusiast

  Points: 104

  More actions

  May 20, 2004 at 8:51 pm

  #85118

  I have a problem where I can't my sp to return me the correct value.

  the sp code is:

  CREATE PROCEDURE getKeyField

  @tableRef NVARCHAR(128),

  @keyField NVARCHAR(128) = NULL OUTPUT

  AS

  SELECT @keyField = constraint_name FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS (NOLOCK) WHERE TABLE_NAME = tableRef AND CONSTRAINT_TYPE = 'PRIMARY KEY'

  ***************

  If run the sp from Query Analyser, it works, but not from the asp.net web pages.

  The output parameter always returns null.

  Does anyone have any idea?

  Thanks,

  Eka

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  May 21, 2004 at 4:50 am

  #507250

  TRY THIS.......

  CREATE PROCEDURE getKeyField

  @tableRef sysname

  AS

  SELECT constraint_name FROM

  INFORMATION_SCHEMA.TABLE_CONSTRAINTS (NOLOCK)

  WHERE TABLE_NAME = @tableRef AND CONSTRAINT_TYPE = 'PRIMARY KEY'

  exec getKeyField 'TABLENAME'

  
  Andy.