会python真的可以为所欲为0(回)
332天前
这里还有人吗1(回)
517天前这里还有人吗0(回)
517天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
741天前到处都是羊，不想上班0(回)
821天前
鸽子
0(回)
826天前SELECT udf.NAME, |
SCHEMA_NAME(udf.schema_id), |
m.DEFINITION |
FROM [sys].[all_sql_modules] m |
INNER JOIN [sys].[all_objects] udf ON m.object_id = udf.object_id |
WHERE DEFINITION LIKE '%create function%' |
AND udf.type IN ( |
'TF', |
'FN', |
'IF', |
'FS', |
'FT' |
) |
AND CAST(CASE |
WHEN udf.is_ms_shipped = 1 |
THEN 1 |
WHEN ( |
SELECT major_id |
FROM sys.extended_properties |
WHERE major_id = udf.object_id |
AND minor_id = 0 |
AND class = 1 |
AND NAME = N'microsoft_database_tools_support' |
) IS NOT NULL |
THEN 1 |
ELSE 0 |
END AS BIT) = 0 |
by: 发表于：2017-09-07 15:52:28 顶(0) | 踩(0) 回复
??
回复评论