insert into dbo.Tb_SVNAdminOwner(URLID,UserID,[Type],UserName,DomainAccount,CreateDateTime,CreateUserID,CreateUserName)
values((select ID from dbo.Tb_SVNURL where SVNURL='http://techw12-2.wind.com.cn:8080/svn/testfirst/testfolder/Test2'),
'2',1,'李明','mli','2011-11-23 0:00:00','22','李明')
values((select ID from dbo.Tb_SVNURL where SVNURL='http://techw12-2.wind.com.cn:8080/svn/testfirst/testfolder/Test2'),
'2',1,'李明','mli','2011-11-23 0:00:00','22','李明')
修改为:
insert into dbo.Tb_SVNAdminOwner(URLID,UserID,[Type],UserName,DomainAccount,CreateDateTime,CreateUserID,CreateUserName)
select ID,'2',1,'李明','mli','2011-11-23 0:00:00','22','李明'
from dbo.Tb_SVNURL
where SVNURL='http://techw12-2.wind.com.cn:8080/svn/testfirst/testfolder/Test2'