根据表名得到除主键外的所有字段

Create FUNCTION [dbo].[fn_FieldsExceptPK]
(
      @TableName Varchar(50)
)
RETURNS Varchar(MAX)
AS
BEGIN
      DECLARE @ReturnValue As Varchar(MAX)
      Set @ReturnValue=''

      Declare @PKName As Varchar(50)

      SELECT @PKName=syscolumns.name
      FROM syscolumns,sysobjects,sysindexes,sysindexkeys
      WHERE syscolumns.id = OBJECT_ID(@TableName)
      AND sysobjects.xtype = 'PK'
      AND sysobjects.parent_obj = syscolumns.id
      AND sysindexes.id = syscolumns.id
      AND sysobjects.name = sysindexes.name
      AND sysindexkeys.id = syscolumns.id
      AND sysindexkeys.indid = sysindexes.indid
      AND syscolumns.colid = sysindexkeys.colid
     
      Declare @Count as Int
     
      Select @Count=Count(1)
      From syscolumns
      Where syscolumns.id = OBJECT_ID(@TableName)
      AND Upper(syscolumns.name)<>@PKName


     
      Declare @i as Int
      Set @i=1

      While  (@i<=@Count)
      Begin
            Declare @name As Varchar(50)

            Select @name=Fields.Name
            From(
            Select syscolumns.name,syscolumns.colid,Row_Number() Over(Order By syscolumns.colid) As Rn
            From syscolumns
            Where syscolumns.id = OBJECT_ID(@TableName)
            AND Upper(syscolumns.name)<>@PKName) As Fields
            Where Fields.Rn=@i

            Set @ReturnValue=@ReturnValue+@name
            IF(@i<@Count)
            Begin
                  Set @ReturnValue=@ReturnValue+','
            End
            Set @i=@i+1
      End
      RETURN @ReturnValue

END