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