Stored procedure
Jeg har en stored procedure her, men den siger hele tiden \"Must declare the variable strSubscriberName\", og som i kan se er den øverst oppe. Hvad gør jeg galt?CREATE PROCEDURE [dbo].[NEWS_InsertSubscriber]
(
@intCategoryID int
@strSubscriberName varchar(255) = \'no_name\'
@strEmail varchar(255)
@strPhone varChar(16) = \'no_phone\'
@strMailsubscribe char(1) = \'n\'
@strPhoneSubscribe char(1) = \'n\'
)
AS
/*DECLARE @subscriber_id int*/
Insert Into News_Subscriber(SubscriberName,Email,Phone,MailSubscribe,PhoneSubscribe)
VALUES( @strSubscriberName, @strEmail , @strPhone , @strMailsubscribe , @strPhoneSubscribe )
/*
Insert Into News_CategorySubscription(FK_NEWS_Category_ID,FK_NEWS_Subscriber_ID)
VALUES(@CategoryID,(SELECT ID from News_Subscriber WHERE Email = @Email))
*/
GO
