declare @s varchar(200)
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\ComputerName\ActiveComputerName','ComputerName',@s output
print @s
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\ComputerName\ActiveComputerName','ComputerName',@s output
print @s
exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName','ComputerName',@s output
print @s
例如:select @@servername;
go;
就会返回服务器的名字
因为他可以被修改!