1.按最后修改时间降序排序
SELECT
p.name AS ProcedureName,
p.create_date AS CreationDate,
p.modify_date AS LastModifiedDate,
m.definition AS ProcedureDefinition
FROM
sys.procedures AS p
INNER JOIN
sys.sql_modules AS m ON p.object_id = m.object_id
ORDER BY
p.modify_date DESC;
SELECT
p.name AS ProcedureName,
p.create_date AS CreationDate,
p.modify_date AS LastModifiedDate,
m.definition AS ProcedureDefinition
FROM
sys.procedures AS p
INNER JOIN
sys.sql_modules AS m ON p.object_id = m.object_id
WHERE
m.definition LIKE '%xxxxx%'
ORDER BY
p.modify_date DESC;
2.NOT LIKE相关
DECLARE @p_source VARCHAR(256) = 'h5us4hz09';
-- 检查 @p_source 是否匹配任何指定的模式
IF @p_source NOT LIKE 'h5us4hz01%'
AND @p_source NOT LIKE 'h5us4hz02%'
AND @p_source NOT LIKE 'h5us4hz03%' -- 根据需要添加更多条件
BEGIN
PRINT @p_source; -- 输出不匹配的源字符串
END
可以改成下面:
DECLARE @p_source VARCHAR(256) = 'h5us4hz09';
-- 使用一个临时表变量来存储模式
DECLARE @Patterns TABLE (Pattern VARCHAR(256));
-- 插入所有的模式
INSERT INTO @Patterns (Pattern) VALUES
('h5us4hz01%'),
('h5us4hz02%'),
('h5us4hz03%'); -- 在这里添加或删除模式
-- 采用交叉连接和聚合函数来查找任何匹配项
IF NOT EXISTS (
SELECT 1
FROM @Patterns
WHERE @p_source LIKE Pattern
)
BEGIN
PRINT @p_source;
END