表库模板设计时默认数据规范字段双击打开的方法及部门自动编码

表库模板设计时默认数据规范字段双击打开的触发器

CREATE TRIGGER trg_Insert_tabDIYTableField
ON tabDIYTableField
AFTER INSERT
AS
BEGIN
-- 更新刚刚插入的记录，设置数据规范显示时机为双击时显示
UPDATE tabDIYTableField
SET bAlwaysShowSelWin = 3
FROM inserted
WHERE tabDIYTableField.fieldID = inserted.fieldID
END

另外再补充一个创建部门时自动给部门加上编号的触发器代码
CREATE TRIGGER [dbo].[tabDepartment_CFQ]
ON [dbo].[tabDepartment]
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
--自动设置部门编码
SET NOCOUNT ON;
UPDATE tabDepartment SET BM=RIGHT('00000'+CAST(DeptID AS VARCHAR(500)),3)+'B'
END