create PROCEDURE GWD_AddUser
@UserID INT OUTPUT,
@UserName nvarchar(20),
@UserKey varchar(20),
@UserEmail varchar(50)
AS
begin
INSERT [GWD_User] ([UserName],[UserKey],[UserEmail],[UserRegTime],[UserLastTime]) VALUES
(
@UserName,
@UserKey,
@UserEmail,
getdate(),
getdate()
)
select @UserID=@@Identity
insert GWD_User_Score values(@@Identity,0,0,0)
end
-------------------
ALTER PROCEDURE GWD_Ask_My
@UserID int
AS
SELECT
A.AskID,A.AskTitle,A.AskPostTime,A.AskIsOK,A.AskGoal,A.AskClass,A.AskReplyNum,AC.AskClassName
FROM [GWD_Ask] As A
join [GWD_Ask_Class] As AC
on A.UserID=@UserID and A.AskClass=AC.AskClassID
