首先寫了個自定義函數
CREATE FUNCTION f_EmpId()
RETURNS nchar(17)
AS
BEGIN
RETURN(SELECT 'CMI'+CONVERT(varchar,GETDATE(),112)+RIGHT(100+ISNULL(RIGHT(MAX(EmpId),3),0),3)
FROM Init_Employee WITH(XLOCK,PAGLOCK))
END
GO怎樣把它作為表Init_Employee的EmpId默認值啊,我直接在表Init_Employee-修改-選中列EmpId-默認值或綁定-輸入f_EmpId(),出入數據時EmpId的列就是 f_EmpId(),請問應該怎麼寫
CREATE FUNCTION f_EmpId()
RETURNS nchar(17)
AS
BEGIN
RETURN(SELECT 'CMI'+CONVERT(varchar,GETDATE(),112)+RIGHT(100+ISNULL(RIGHT(MAX(EmpId),3),0),3)
FROM Init_Employee WITH(XLOCK,PAGLOCK))
END
GO怎樣把它作為表Init_Employee的EmpId默認值啊,我直接在表Init_Employee-修改-選中列EmpId-默認值或綁定-輸入f_EmpId(),出入數據時EmpId的列就是 f_EmpId(),請問應該怎麼寫
EmpId char(8) PRIMARY KEY DEFAULT dbo.f_EmpId(),
col int)