提供,我的论坛会员金币可以清零了,衷心感谢!升级会员金钱小于0的语句
SQL:
update BBS_user set money=0 where money<0
新增UID字段
declare @acc int
declare @name nvarchar(50)
declare @I int
select @acc = isnull(count(1),0) from bbs_user where UID is null
Set @I = 1
if(@acc<>0)
begin
while(@acc<>0)
begin
SELECT top 1 @name = name from bbs_user where UID is null order by jointime
update bbs_user set UID =@I WHERE name = @name
Set @I = @I + 1
Set @acc = @acc - 1
end
end



博客
资料
短消息
搜索
加为好友
成为Fans
江苏



