TiMa

  • Linux下buff/cache占用过大处理

    echo 1 > /proc/sys/vm/drop_caches

    echo 2 > /proc/sys/vm/drop_caches

    echo 3 > /proc/sys/vm/drop_caches

    sync && echo 1 > /proc/sys/vm/drop_caches && echo 2 > /proc/sys/vm/drop_caches && echo 3 > /proc/sys/vm/drop_caches


  • Skype 网页html代码code

    <a href="skype:<username>?<action>"> Link Text</a>
    <a href="skype:example123?chat">Start Chat</a>

    action : userinfo / chat / call / add / voicemail / sendfile


  • B1 禁止删除报表触发器

    create trigger [dbo].[BBKZ] ON [dbo].[OUQR]

    instead of  update

    AS

    DECLARE @FirstTest VARCHAR(1000)

    DECLARE @LastTest VARCHAR(1000)

    SELECT @FirstTest=convert(varchar(1000),QString)  FROM deleted

    SELECT @LastTest= convert(varchar(1000),QString) FROM inserted

    IF @FirstTest IS NOT NULL AND @LastTest =””

    BEGIN

    raiserror(‘  不允许删除报表’,16,8)

    rollback

    END