SQL SERVER 查找出不含自增项和计算字段的自定义函数

IF EXISTS (SELECT * FROM sysobjects WHERE name = 'B_GetTableWithOutCompute' AND user_name(uid) = 'dbo')
    DROP FUNCTION B_GetTableWithOutCompute;
GO

CREATE FUNCTION dbo.B_GetTableWithOutCompute
(
    @TableName    varchar(100)
)
RETURNS varchar(MAX)
WITH ENCRYPTION
AS
BEGIN
    declare @col varchar(MAX)='' 
    select @col=@col+','+name 
    FROM syscolumns where id=object_id(@TableName) 
    AND name  NOT IN (
       SELECT a.name
       FROM sys.columns a , sys.objects b
       where a.object_id= b.object_id and b.name=@TableName 
       AND (a.is_identity=1 OR a.is_computed=1)
    ) 
    ORDER by colid
    set @col=stuff(@col,1,1,'')
    RETURN @col
 END
GO