HamidTatalo
چهارشنبه 27 بهمن 1389, 14:16 عصر
دوستان من اين كد رو در داخل stored procedure نوشتم :
@Name nvarchar(400)
@ShortDescription nvarchar(MAX)
@FullDescription nvarchar(MAX)
@AdminComment nvarchar(MAX)
@TemplateID int
@ShowOnHomePage bit
@MetaKeyword nvarchar(400)
@MetaDescription nvarchar(4000)
@MetaTitle nvarchar(400)
@SEName nvarchar(100)
@AllowCustomerReviews bit
@AllowCustomerRatings bit
@RatingSum int
@TotalRatingVotes int
@Published bit
AS
INSERT INTO tbl_Product
([Name], ShortDescription, FullDescription, AdminComment, TemplateID, ShowOnHomePage,
MetaKeyword, MetaDescription, MetaTitle, SEName, AllowCustomerReviews,
AllowCustomerRatings, RatingSum, TotalRatingVotes, Published, Deleted, CreatedOn, UpdatedOn)
VALUES (@[Name], @ShortDescription, @FullDescription, @AdminComment, @TemplateID, @ShowOnHomePage,
@MetaKeyword, @MetaDescription, @MetaTitle, @SEName, @AllowCustomerReviews,
@AllowCustomerRatings, @RatingSum, @TotalRatingVotes, @Published, 0, GETDATE(), GETDATE())
RETURN
ولي هنگام ذخيره كردن خطاي زير رو ميده
Incorrect syntax near '@ShortDescription'.
Must Declare the scaler variant "@"
خيلي واجبه ممنون:گریه:
@Name nvarchar(400)
@ShortDescription nvarchar(MAX)
@FullDescription nvarchar(MAX)
@AdminComment nvarchar(MAX)
@TemplateID int
@ShowOnHomePage bit
@MetaKeyword nvarchar(400)
@MetaDescription nvarchar(4000)
@MetaTitle nvarchar(400)
@SEName nvarchar(100)
@AllowCustomerReviews bit
@AllowCustomerRatings bit
@RatingSum int
@TotalRatingVotes int
@Published bit
AS
INSERT INTO tbl_Product
([Name], ShortDescription, FullDescription, AdminComment, TemplateID, ShowOnHomePage,
MetaKeyword, MetaDescription, MetaTitle, SEName, AllowCustomerReviews,
AllowCustomerRatings, RatingSum, TotalRatingVotes, Published, Deleted, CreatedOn, UpdatedOn)
VALUES (@[Name], @ShortDescription, @FullDescription, @AdminComment, @TemplateID, @ShowOnHomePage,
@MetaKeyword, @MetaDescription, @MetaTitle, @SEName, @AllowCustomerReviews,
@AllowCustomerRatings, @RatingSum, @TotalRatingVotes, @Published, 0, GETDATE(), GETDATE())
RETURN
ولي هنگام ذخيره كردن خطاي زير رو ميده
Incorrect syntax near '@ShortDescription'.
Must Declare the scaler variant "@"
خيلي واجبه ممنون:گریه: