SQLServer实用操作小技巧集合（一）

DECLARE @Name as NVARCHAR(128)
DECLARE @Owner as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)

织梦内容管理系统

DECLARE curObject CURSOR FOR
select 'Name' = name,
'Owner' = user_name(uid)
from sysobjects
where user_name(uid)=@OldOwner
order by name

OPEN curObject
FETCH NEXT FROM curObject INTO @Name, @Owner
WHILE(@@FETCH_STATUS=0)
BEGIN
if @Owner=@OldOwner
begin
set @OwnerName = @OldOwner '.' rtrim(@Name)
exec sp_changeobjectowner @OwnerName, @NewOwner
end
-- select @name,@NewOwner,@OldOwner

dedecms.com

FETCH NEXT FROM curObject INTO @Name, @Owner
END dedecms.com

close curObject
deallocate curObject 织梦好，好织梦

GO

SQL SERVER中直接循环写入数据
没什么好说的了，大家自己看，有时候有点用处

dedecms.com

declare @i int
set @i=1
while @i<30
begin
insert into test (userid) values(@i)
set @i=@i 1
end 内容来自dedecms

看完这篇，您有何感觉呢？