?? ????? ??????? append ????? ??? ??????????? ?? ????? Access ?? Access 2002

?????? ????????? ?????? ?????????
???? ???????: 294923 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ?????? ??????? ??????? ???????? ? ?????? ?????? ??????????.

??? ????? ??? ?????? ??? ??? ????? Microsoft Access (.adp).

?????? ??? ????? Microsoft Access 2000 ?? ??? ???????? ???? 229681.
????? ???? | ?? ????

?? ??? ??????

???????

??? ?????? ????? ????? ??? ????? ????????? ?? ????? Microsoft Access, ?? ????? ????? ????? ???????:
?? ???? ????? ???? ???? ?????? ????? ?? ?????? ' ??? ?????? ' ??? ????? IDENTITY_INSERT ??? ?????.

?????

??? ????? ????? ?????? SQL Server ???? (??? ?? ??? SQL Server 2000 Desktop Engine) ?? ????? ?????? IDENTITY_INSERTOFF.

??? ????? ????? ????? ?????? ???? Microsoft Access ????? ??? ???????? "??? ??????" ? ??? ????? ????? ??? SQL Server ????? IDENTITY. ???? ??? ?????? "????? ??????" ???? ????? ??????? ?????? ?? ??????? IDENTITY ??? ???? ???? ????? ?????? ?? ???? IDENTITY ????? ????? ???? IDENTITY_INSERT ???? ?????? ??? ?????. ????? ?? ????? ???????? ?? ???? IDENTITY ??? ???? ????? ?????? IDENTITY_INSERT ??? ON.

????

????? ??????? ????? SET IDENTITY_INSERT ????? ???? IDENTITY_INSERT. ????? SET IDENTITY_INSERT ????? ???? ?? ??? ???? ??? ????? UPDATE ?? INSERT ???? ????? ?? ?????? ???????? ???? IDENTITY. ???? ?????? ?????? ?????? IDENTITY_INSERT ????? NewEmployees.
   SET IDENTITY_INSERT NewEmployees ON
				

??????? ????

????? ????? ????? ?? ????

  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ?? ?????? "????? ??????" ? ???? ??? ???? ???????? ?? ???? ??? ??? ?? ??????? ?????.
  3. ?? ??????? ????? ? ???? ??? ???. ?? ???? ?????? ??? ???? ???? ???? NewEmployees ?? ?????? ??? ??????. ???? ??? ?????.
  4. ????? ??????? ???? ?? ????? ????? "?????" ?? ?? ?????? ???? ?????? "????? ???? ??? ????? ????? ?? ?????????.
  5. ?? ??????? ???? ???? ??? ??? SQL.
  6. ???? ????? INSERT INTO ??????? ?? ???? SQL. ????? ??? ?????? ????? ??????? ??????:
       INSERT INTO 
              NewEmployees (EmployeeID, LastName, FirstName, Title,
              TitleOfCourtesy, BirthDate, HireDate, Address, City, Region,
              PostalCode, Country, HomePhone, Extension, Photo, Notes,
              ReportsTo)
       SELECT 
              Employees.EmployeeID, Employees.LastName, Employees.FirstName,
              Employees.Title, Employees.TitleOfCourtesy, Employees.BirthDate,
              Employees.HireDate, Employees.Address, Employees.City,
              Employees.Region, Employees.PostalCode, Employees.Country,
              Employees.HomePhone, Employees.Extension, Employees.Photo,
              Employees.Notes, Employees.ReportsTo
       FROM 
              Employees;
    					
  7. ???? ????????? qryAppend ?? ?? ?????? ?????????.
  8. ?? ??????? ?????? ??? ??? ????? ?????? ?????? ???????? ? ?? ???? ??? ????? ????? ?????.
  9. ???? ??????? ???????? ?? "????? ????? ?????" ?? ???? ??????? ????????? ???????? ??? ?? ???? ?????:
    ????? ????? ?????? ?????: ???
    ??????? ???? ???? ????? ??? ???? SQL: ????? ???? ???????
    ????? ???? ?????? ?????? ???????: ?? ?????
    ????? ????? ????/???? Access ????: ???
  10. ??? ?????? "????? ????? ?????" ????? "????? ????? ?????".
  11. ???? ????? ??????? qryAppend ????? ?????? ????? ?????.
  12. ?????? INSERT IDENTITY ??? ON ?????? ????? ?????? ?? SQL ??? ????? qryAppend ????? ?????? ??? ?????? ???????? AS:
       SET IDENTITY_INSERT NewEmployees ON
    						
    ??? ????????? ??? ????? ???? ?????? ?? ???? ??????:
       ALTER PROCEDURE qryAppend
       AS
       SET IDENTITY_INSERT NewEmployees ON
       INSERT INTO 
              NewEmployees (EmployeeID, LastName, FirstName, Title,
              TitleOfCourtesy, BirthDate, HireDate, Address, City, Region,
              PostalCode, Country, HomePhone, Extension, Photo, Notes,
              ReportsTo)
       SELECT 
              Employees.EmployeeID, Employees.LastName, Employees.FirstName,
              Employees.Title, Employees.TitleOfCourtesy, Employees.BirthDate,
              Employees.HireDate, Employees.Address, Employees.City, 
              Employees.Region, Employees.PostalCode, Employees.Country, 
              Employees.HomePhone, Employees.Extension, Employees.Photo, 
              Employees.Notes, Employees.ReportsTo
       FROM 
              Employees
    					
  13. ??? ??????? ?????? ??????? ?? ?? ?????? ????. ???? ?? ????.

?????

????? ?? ????????? ??? INSERT IDENTITY ???? ??? "??? SQL Server ???????". ?????? ??? "??? SQL Server ???????" ?????? ???? Microsoft ?????? ??? ?????:
http://technet.microsoft.com/en-us/sqlserver/bb331756.aspx

???????

???? ???????: 294923 - ????? ??? ??????: 23/???? ?????/1435 - ??????: 3.3
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbclientserver kberrmsg kbprb KB294923 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????294923

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com