摘要： 1. 先得到旧帐号bbsc的权限：sp_helprotect null,'bbsc'OwnerObjectGranteeGrantorProtectTypeActionColumndboWSCParameterbbscdboGrant Select(All+New)dboWSCParameterTypebbscdboGrant Select(All+New)dboWSCTeambbscdboGrant Select(All+New)dboWSCUserTeamMapbbscdboGrant Select(All+New)PMSv_PMSITEMViewForHI4bbscPMS 阅读全文

摘要： --申明一个游标DECLARE MyCursor CURSOR FOR SELECT TOP 5 FBookName,FBookCoding FROM TBookInfo--打开一个游标 OPEN MyCursor--循环一个游标DECLARE @BookName nvarchar(2000),@BookCoding nvarchar(2000)FETCH NEXT FROM MyCursor INTO @BookName,@BookCodingWHILE @@FETCH_STATUS =0BEGINprint 'name'+@BookNameFETCH NEXT FROM M 阅读全文