October 19, 1999 Registry Extended Stored Procedures By Darren GreenExamples of how to read, write and delete registry values using SQL Server extended stored procedures. These xp's are not documented in SQL Server Books Online and therefore unsupported by Microsoft. xp_regread xp_regread [@rootkey=]'rootkey', [@key=]'key'[, [@value_name=]'value_name'][, [@value=]@value OUTPUT] 1. Check for vaild key EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\' KeyExist ----------- 1 2. Read key as result set EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\', @value_name='defaultLogin' Value Data -------------------- ------ defaultLogin guest 3. Read key into variable DECLARE @value varchar(25) EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\', @value_name='defaultLogin', @value=@value OUTPUT PRINT @value guest xp_regwrite xp_regwrite [@rootkey=]'rootkey', [@key=]'key', [@value_name=]'value_name', [@type=]'type', [@value=]'value', type can be REG_SZ for string values or REG_DWORD for integers 1. Write key and value EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\xp_reg', @value_name='URL', @type='REG_SZ', @value='http://www.swynk.com/friends/green/' xp_regdeletekey xp_regdeletekey [@rootkey=]'rootkey', [@key=]'key' Beware, this will delete the whole key. Use Carefully. 1. Delete whole key EXEC master.dbo.xp_regdeletekey @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\xp_reg' Msg 22001, Level 1, State 22001 RegDeleteKey() returned error 0, 'The operation completed successfully.'
关注
Registry Extended Stored Procedures
By Darren GreenExamples of how to read, write and delete registry values using SQL Server extended stored procedures. These xp's are not documented in SQL Server Books Online and therefore unsupported by Microsoft. xp_regread xp_regread [@rootkey=]'rootkey', [@key=]'key'[, [@value_name=]'value_name'][, [@value=]@value OUTPUT] 1. Check for vaild key EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\'
KeyExist
-----------
1 2. Read key as result set EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\',
@value_name='defaultLogin'
Value Data
-------------------- ------
defaultLogin guest 3. Read key into variable DECLARE @value varchar(25)
EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\',
@value_name='defaultLogin', @value=@value OUTPUT
PRINT @value
guest xp_regwrite xp_regwrite [@rootkey=]'rootkey', [@key=]'key', [@value_name=]'value_name', [@type=]'type', [@value=]'value', type can be REG_SZ for string values or REG_DWORD for integers 1. Write key and value EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
@key='SOFTWARE\xp_reg', @value_name='URL', @type='REG_SZ',
@value='http://www.swynk.com/friends/green/' xp_regdeletekey xp_regdeletekey [@rootkey=]'rootkey', [@key=]'key' Beware, this will delete the whole key. Use Carefully. 1. Delete whole key EXEC master.dbo.xp_regdeletekey
@rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\xp_reg'
Msg 22001, Level 1, State 22001
RegDeleteKey() returned error 0,
'The operation completed successfully.'
假如我想要知道别的扩展存储过程该怎么办呢?