- Joined
- Jan 16, 2007
- Messages
- 17
- Reaction score
- 0
Some1 post solution 4 bounty - infinity bounty.Could u post it here (search button gone :schmoll: waaaaaa
(( so i can't find it...)

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetAccountInfo]
@nAID INT
AS
BEGIN
SET NOCOUNT ON;
SELECT AID,UGradeID,UserID
FROM Accounts
WHERE AID = @nAID
UPDATE Character
SET BP = 1000000
END