T-SQL使用扩展存储过程[master].[dbo].[xp_regread]读取注册表信息。
如下注册表:
Insus.NET为了做演示,写了一个用户自定义函数[dbo].[GetServerLocation]():
View Code
CREATE
FUNCTION
[
dbo
]
.
[
GetServerLocation
]
()
RETURNS NVARCHAR ( 4000 )
AS BEGIN
DECLARE @Location NVARCHAR ( 4000 )
EXEC [ master ] . [ dbo ] . [ xp_regread ] ' HKEY_CURRENT_USER ' ,
' Control Panel\International ' ,
' sCountry ' ,
@Location OUTPUT
RETURN @Location
END
RETURNS NVARCHAR ( 4000 )
AS BEGIN
DECLARE @Location NVARCHAR ( 4000 )
EXEC [ master ] . [ dbo ] . [ xp_regread ] ' HKEY_CURRENT_USER ' ,
' Control Panel\International ' ,
' sCountry ' ,
@Location OUTPUT
RETURN @Location
END