100分求一sql语句简单写法

[comflyer0590]

如下，我想在后面的系统函数fn_listextendedproperty 中调用前面的OBJECT_NAME (id)值作为其中的一个参数(字符串型)，直接这样写语法报错，望大家帮忙！

SELECT OBJECT_NAME (id) AS '表名',crdate AS '创建时间', refdate AS '修改时间',
(SELECT value FROM ::fn_listextendedproperty (NULL, 'user', 'dbo', 'table', OBJECT_NAME (sysobjects.id), null, null))
AS '说明' FROM sysobjects
WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0

[子陌红尘]

借助自定义函数：
----------------------------------------------------------------------------------------------------------------------
create function f_getextendedproperty(@name varchar(1000))
returns sql_variant
as
begin
declare @ret sql_variant
select @ret=value from ::fn_listextendedproperty(NULL, 'user', 'dbo', 'table', @name, null, null)
return @ret
end
go


SELECT
OBJECT_NAME(id) AS '表名',
crdate AS '创建时间',
refdate AS '修改时间',
dbo.f_getextendedproperty(t.name) AS '说明'
FROM
sysobjects t
WHERE
xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0

drop function f_getextendedproperty
go

[撸大湿]

sql_variant 很少见人用


学习

[regithanhu]

路过

[数字化从业者老高]

JF！

[marco08]

学习...

[xeqtr1982]

进来学习下