sqlserver 自定义函数使用Getdate()的变通方法

1，先建一个视图
CREATE view v_getdate
as
select convert(varchar(4), getdate(),20) as dt

2，建立函数

  CREATE FUNCTION f_NextBH()
  RETURNS varchar(50)
  AS

  BEGIN
declare @GetDate varchar(4)
select @GetDate = dt from v_getdate
      RETURN(SELECT 'TYKJ/QC_' + CONVERT(VARCHAR(4),@GetDate) + '_' + RIGHT(10001 + ISNULL(RIGHT(MAX(文件编号), 4), 0), 4)  FROM tb_YiShengJi WITH (XLOCK, PAGLOCK)WHERE (CONVERT(VARCHAR(4), 录入日期, 20) = CONVERT(VARCHAR(4),@GetDate)))
  END