初次报到，做点贡献2：ase device 逆向列表

BlueAeri

有时候需要重建或迁移数据库，拿支笔抄写设备列表很麻烦，下面的一气呵成：
-------------------------------BlueAeri--------------------------------------
select substring('disk init name = "' + substring(name, 1, 22) +
                '", physname = "' + substring(phyname, 1, 79) +
                '", vdevno = ' + convert(varchar,low/power(2,24)) +
                ', size = "' + convert(varchar,((high-low)+1)/512) + 'M"', 1, 120)
        from master..sysdevices
        where cntrltype = 0
        order by low
go
-------------------------------BlueAeri--------------------------------------
disk init name = "master", physname = "C:\sybase\data\master.dat", vdevno = 0, size = "128M"
disk init name = "sysprocsdev", physname = "C:\sybase\data\sysprocs.dat", vdevno = 1, size = "256M"
disk init name = "temp_dev0", physname = "D:\SybaseDev\temp_dev0.dat", vdevno = 2, size = "2048M"

[ 本帖最后由 BlueAeri 于 2007-12-27 17:57 编辑 ]