Sqlserver 常用命令

作者: luohao 更新: 2023-02-03 分类: SQLserver 
--触发器
BEGIN
    IF
        UPDATE ( sale_order_line_id ) BEGIN
            UPDATE stock_move_line 
            SET contract = ( SELECT origin FROM sale_order WHERE ID = ( SELECT sale_order_id FROM sale_order_line WHERE ID = inserted.sale_order_line_id ) )
        FROM
            inserted 
        WHERE
            stock_move_line.ID = inserted.ID 
            AND
            inserted.sale_order_line_id > 0
    END
END

--替换函数
REPLACE('你好啊', '啊', '');

--日期
( nvarchar ( 80 ), a.date, 11 ) AS 日期;--转换为日期为 23/01/13

标签：