Error 128: the name 'Site_Id' is not permitted in this context

15.10.2008, 19:16. **Показов** 1277. **Ответов** 1

Author24 — интернет-сервис помощи студентам

postroil trigger:

T-SQL

CREATE TRIGGER [insert_values] ON [dbo].[Member_Info] 
FOR INSERT
AS
Insert Into Members(Member_Id,Site_Name,Site_Id,Country_Id,Currency_Id,Nb_Of_Categories,Category1_Id,Category2_Id,Category3_Id,Category4_Id,Category5_Id) Values(inserted.Member_Id,'inserted.Site_Name',inserted.Site_Id,inserted.Country_Id,inserted.Currency_Id,inserted.Nb_Of_Categories,inserted.Category1_Id,inserted.Category2_Id,inserted.Category3_Id,inserted.Category4_Id,inserted.Category5_Id)

rugaetsa :

Error 128: the name 'Site_Id' is not permitted in this context.
Only constants,expressions,or variables,allowed here.Column names are not permitted.

datatype:

Member_Id (int)
Site_Name (varchar)
Site_Id (smallint)
ostalnie (tinyint)

@Glory · 15.10.2008, 21:47

T-SQL

Insert Into Members(Member_Id,Site_Name,Site_Id,Country_Id,Currency_Id,Nb_Of_Categories,Category1_Id,Category2_Id,Category3_Id,Category4_Id,Category5_Id) select Member_Id, Site_Name, Site_Id, Country_Id, Currency_Id, Nb_Of_Categories, Category1_Id, Category2_Id, Category3_Id, Category4_Id, Category5_Id from inserted

	15.10.2008, 21:47