@subject char(255),
@message text,
@date datetime,
@from char(100),
@name char(100),
@username char(100),
@telephone char(100),
@email char(100),
@uniqueid char(30)
Frågan#1
Jag har följande kod:
CREATE PROCEDURE sp_InsertSupportQ
@subject (char) (255),
@message (text),
@date (datetime),
@from (char) (100),
@name (char) (100),
@username (char) (100),
@telephone (char) (100),
@email (char) (100),
@uniqueid (char) (30)
AS
INSERT INTO SupportQ
(Subject, Message, [Date], [From], [Name], Username, Telephone, Email, UniqueID)
values
(@subject, @message, @date, @from, @name, @username, @telephone, @email, @uniqueid)
GO
Must declare the variable @subject när jag försöker spara SP:n
Vad är fel?