记录下今天用到的 游标 ： DECLARE @TempID INT DECLARE @Number INT SET @Number=1 DECLARE myCursor CURSOR FOR SELECT MemberID FROM dbo.Member OPEN myCursor FETCH NEXT FROM myCursor INTO @TempID WHILE(@@fetch_status=0) BEGIN UPDATE dbo.Member
记录下今天用到的游标：
DECLARE @TempID INT
DECLARE @Number INT
SET @Number=1
DECLARE myCursor CURSOR FOR
SELECT MemberID FROM dbo.Member
OPEN myCursor
FETCH NEXT FROM myCursor INTO @TempID
WHILE(@@fetch_status=0)
BEGIN
UPDATE dbo.Member
SET MemberName='测试会员'+ CONVERT(VARCHAR,@Number,50)
WHERE MemberID=@TempID
SET @Number=@Number+1
FETCH NEXT FROM myCursor INTO @TempID
END
CLOSE myCursor
DEALLOCATE myCursor
待续.....
适合初学的标准三层架构，采用ajax，页面布局div+css符合w3c，用vs自带的sqlserver，免配置sqlserver，使用方便，里面共有5个项目，点击最外层的.sln直接可运行。网站采用asp.net 用户角色配置（membership，UserRoles），用户角色、权限可在asp.net配置里修改，注册，登陆均采用asp.net登陆控件，网站根据用户角色自定义sitemap，基本上
DECLARE @id INT
DECLARE @money INT
DECLARE cursor1 CURSOR FOR
SELECT IntegrateCardID,RemainSum FROM dbo.IntegrateCard
OPEN cursor1
FETCH NEXT FROM cursor1 INTO @temp,@money
WHILE ( @@fetch_status = 0 )
BEGIN
UPDATE dbo.IntegrateCard
SET PreRecharge = @money
WHERE IntegrateCardID = @id
FETCH NEXT FROM cursor1 INTO @TempMemeberID
END
CLOSE cursor1
DEALLOCATE cursor1
