创建查看某字段是否存在的函数

if exists (select * from sysobjects where name = 'IsExistsField')
 drop function IsExistsField
go

CREATE FUNCTION IsExistsField
( 
 @tableName VARCHAR(64)
 ,@FieldName VARCHAR(64)
) 
RETURNS int
AS 

BEGIN
 DECLARE @tmpAmount INT
 SET @tmpAmount = 0
 SELECT @tmpAmount = COUNT(SYSCOLUMNS.name)
  FROM SYSCOLUMNS,SYSOBJECTS
  WHERE SYSCOLUMNS.ID = SYSOBJECTS.ID
   and SYSOBJECTS.name = @tableName
   AND SYSCOLUMNS.name = @FieldName
  

 RETURN @tmpAmount

END
go