|
|
|
|
| To run this code you have to download reg.exe file which can be downloaded from |
 Click here to copy the following block | Alter proc uspTestReg
@MC varchar(255)='localhost'
,@Key varchar(255)='\HKLM\HARDWARE\DESCRIPTION\System'
,@Value1 varchar(255)='SystemBIOSVersion'
as
declare @cmd varchar(100)
declare @s1 varchar(100)
declare @ret1 varchar(50)
set @cmd='c:\reg query \\' + @MC + @Key + ' /v ' + @value1
create table #a(cmdout varchar(2000) NULL)
Insert into #a
exec master.dbo.xp_cmdshell @cmd
select * from #a
set @ret1=''
select @s1=cmdout from #a where cmdout like '%' + @Value1 + '%'
select @ret1 =right( rtrim(ltrim(@s1)),len(rtrim(ltrim(@s1)))-patindex('%REG_SZ%',rtrim(ltrim(@s1)))-len('REG_SZ'))
select @ret1
go |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|