存储过程

 

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