SQL Syntaks fejl II
Hvad er fejlen her:CREATE PROCEDURE dbo.up_parmins_UserT_CCT
(@Firstname VarChar(50),
@Lastname VarChar(50),
@EmailAddress VarChar(50),
@Username VarChar(30),
@Password VarChar(10),
@CCType VarChar(20),
@ExpMonth Int,
@ExpYear Int,
@CCNumber Uniqueidentifier,
@Donations Money) AS
INSERT INTO User_T (First_Name_VC, Last_Name_VC,
Email_Address_VC, User_Name_VC, Password_VC,
Creditcard_Type_VC, Creditcard_Exp_Month_IN,
Creditcard_Exp_Year_IN, Creditcard_Number_UI,
Donations_MN) VALUES (@Firstname, @Lastname,
@EmailAddress, @Username, @Password, @CCType,
@ExpMonth, @ExpYear, @CCNumber, @Donations)
JOIN Creditcard_T ON
Creditcard_T.Creditcard_ID = User_T.Creditcard_ID
WHERE User_Name_VC = @Username AND
Password_VC = @Password
Jeg får fejlmeddelelsen:
Server: Msg 156, Level 15, State 1, Procedure up_parmins_UserT_CCT, Line 20
Incorrect syntax near the keyword 'JOIN'.
