_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › 朱覦レ觸願鍵

select
    logical_name
,   physical_name
,   [朱.レ]
,   substring(reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)), 1, charindex('.', [朱.レ])-1) [朱]
,   substring(reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)), charindex('.', [朱.レ])+1, len([朱.レ])) [レ]
from (
    SELECT 
        name logical_name
    ,   physical_name
    ,   reverse(substring(reverse(physical_name), 1, charindex('\', reverse(physical_name))-1)) [朱.レ]
    FROM sys.database_files WHERE type = 0 
) t
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

襷 螳 瑚 企 ()讌 覈詩. 蠏瑚 ろ 蟆 覃 襴糾 . ( 讌)