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