????? ????? ??????? ??????? ?????????? ?? ????/???? Access 2002

?????? ????????? ?????? ?????????
???? ???????: 287728 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???????? ????/???? Access ? ????? ????? ??????? ??????? ?? ?? ?? SQL Server ? Microsoft SQL Server 2000 Desktop Engine. ??? ????? ?? ?? ????? ?? ???? ??????? ?? ??? ????? ?? ?????? "????? ??????" ? ??? ??????? ??????? ???????? ????????? ???? ????????? ??????? ????? ????.

??????: ????? ???? Microsoft SQL Server 2000 Desktop Engine ???? ????? ???????? ?? Microsoft "(MSDE).

??? ????? ???? ???? ?? ????? ?????? ?????? ?? ??? Microsoft SQL Server 2000 Desktop Engine ?? SQL Server "? ??? ????? ?????? ?? ????? ?????? tempdp. ??? ???? ????? Access ????? ???????? ????? ???????? ??? ??????? ??????? ???? ??? ?? ??? ??????? (???? ??? ????? ??????). ???? ??? ????? ???? ??????? ?????? ???????? ?? ????? ?????? ??????, ????/???? ?????? ?? ??? ??? ??????. ??? ???? ??? ???? ?????? ????? ?? ????? ?????? ?????? ???? ????????? ??????? ?????? ??????? ???????.

???? ?????? ??????:
  • ????? ????? ???? ???? ???? ????????? ???????.
  • ????? ????? ?????? ?? ?????? ???? ???????? ?? ?????? ?????? ?? ????? ????????.

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

  1. ??? ????? Access ?????? ?????? ?????? Microsoft SQL Server 2000 Desktop Engine ?? SQL Server.
  2. ?? ?????? "????? ??????" ? ???? ??? ????????? ???????? ???? ??????.
  3. ???? ??? ????. ?? ???? ?????? ??????? ???? ? ???? ??? ????? ?? ????? ???? ?? ???? ??? ?????.
  4. ????? ???????? ????? ?????? ?? ??????? ?????? ??????:
    CREATE PROCEDURE CreateATable
    AS
    CREATE TABLE ##ThisIsATest
    (
        MyPK int IDENTITY (1,1),
        MyChar char(10)
    )
    					
  5. ??? ??????? ?????? ?? ????? ????????? CreateATable ?? ?? ?????? ????.
  6. ?????? ??????? ?????? ???? ????? ??????? ??? ????? ?? ?? ?????? "????? ??????" ? ???? ??? ?????.
  7. ???? ????? ???? ????? ?? ?????? ?????? ##ThisIsATest ??? ?? ???????.

????? INSERT SELECT ??????? ?? ???? ????? ?? ??? ???????? ?? ????? ????????

  1. ??? ????? ??????? ???????? ?? ?????? "????? ??????? ????" ? ???? ??? ????????? ???????? ???? ??????.
  2. ???? ??? ????. ?? ???? ?????? ??????? ???? ? ???? ??? ????? ?? ????? ???? ? ???? ??? ????? ?? ?? ???? ???????? ????? ??????:
    CREATE PROCEDURE InsertSelect
    AS
    SET NOCOUNT ON
    INSERT ##ThisIsATest Values('1stRecord')
    INSERT ##ThisIsATest Values('2ndRecord')
    SELECT * FROM ##ThisIsATest
    					
  3. ??? ??????? ?????? ?? ????? ????????? InsertSelect ?? ?? ?????? ????.
  4. ?????? ??????? ?????? ???? ????? ??????? ??? ????? ?? ???? ?????? ??????? ????? ?? ??? ?????? ?????? ##ThisIsATest. ????? ??? ????? ?? ??????? ?????? ?????? ????? ????.



?????

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









???????

???? ???????: 287728 - ????? ??? ??????: 04/?? ??????/1428 - ??????: 3.3
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbclientserver kbhowtomaster KB287728 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????287728

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

 

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