Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.
Printable View
Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.
i want to know it too, if you don't mind telling?Quote:
Originally Posted by Phoenix
I dont want to quote his post that this community never helps. But take a look at him o.O
yeh true..Quote:
Originally Posted by llMafiall
fixed
/close please..
and he is saying the comunity won't help..
fine you tell us how u fixed >.<
Yea sure..Quote:
Originally Posted by Phoenix
The cod should be:
Code:/****** Object: StoredProcedure [dbo].[spGetAccountInfo] Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROC [dbo].[spGetAccountInfo]
@AID int
, @ServerID int = 0
AS
BEGIN
SET NOCOUNT ON
SELECT AID, UserID, UGradeID, Name, HackingType
, DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth
, DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour
, DATEPART(mi, EndHackingBlockTime) AS HackBlockMin
FROM Account(NOLOCK) WHERE AID = @AID
update Account set LastLoginTime = getdate(), ServerID = @ServerID where AID = @AID
END
Take a look at your self nab.Quote:
Originally Posted by llMafiall
Don't break your ass.. Just ask for it why QQ ?Quote:
Originally Posted by jur13n