INF: ????????? ??? ???? SQL 6.5 ???? ???? ??? 6.0 ?????????

?????? ????????? ?????? ?????????
???? ???????: 152032 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ??????? ??? ????? ????????? ???? ????? ??? Microsoft SQL Server ??????? 6.5 ???? ?? ???? ??? ????????? ?????? ?? ???????? ?? SQL Server ??????? 6.0.

?????????:
  1. ??????? ???? ??????
  2. ???? ?????? ????? ??????? ?????????? ?? ?????
  3. ????????? ??????? ??????
  4. ??????? ????????
  5. FROM ????? ???? ??????
  6. SELECT DISTINCT ?? ORDER
  7. ??? ????? ????? ?????? ????? ?????
  8. SELECT INTO ?? CREATE VIEW ???? ??? ??????
  9. ??????? RAISERROR @@ ??? ??? 0 ??? ??? ??????? 10 ?? ???
  10. ????? ??? ???????: sp_sqlregister
  11. ????????? ?????? ?????? ??? ?????? ????????
  12. ??? ?????? ??? ?????? "??????? ?????"
  13. ???? ?????: MSDTC
  14. ???? ????????? ?? ???? ????? EXECUTE ?? ???????
  15. ??????? ?????? ????? ODBC
  16. ???? ???? JOIN ? ????? ???? 204
  17. ???????? ???? ?? ??????? ?? ?????????
  18. SELECT INTO ??? ???? "????? ???????"
  19. ??????? ISQL/????? ??????? ??????? ???? ??? ????? ??? ????
  20. ??? ????? ?? ?? CHECK ? ???? DEFAULT ????????? ????????
  21. ????? ??? ??????: ???? ????
  22. VBSQL.vbx ??????? VBSQL.ocx
  23. ??? ?? ????? Showplan ??????
  24. ????? ????????? ????????
  25. ???????? ??????????

??????? ????

1. ??????? ???? ??????

???? ???? ??? ????????? ??? ????? ??????: ????? ????? ????? ?? ????? ???? ?? ??????? ??? ??????? ?? ????? ??? ????? ???? ?????. ????? ?? ?????????? ???? "??? SQL Server 6.5 ???????" ? ?????? ?? SQL Server 6.5 ??? 4: "?? ?? ???? ?? SQL ????????."

2. ?????? ????????? ????? ????????? ?????????? ?? ?????

???? ???? ?????? ?? ????????? ??? ??????? ????? ??????. ?? ??? ????? ?? ????? ?????? ??????? ????? ??????? ??????? ?? ??????? 6.5 SQL Server. ?? ??? ???????? ?? ????? ????? ??????? ?????? ????? ?????? ????? ?????????. ????? ?? ?????????? ???? "??? SQL Server 6.5 ???????" ? ?????? ?? SQL Server 6.5 ??? 4: "?? ?? ???? ?? SQL ????????."

3. ???? ????????? ???????

?????? ????? ?????????? ??? ?????? ??????? ??????? ?? MSSQL ????? ?? SQL60 (??? ?? 6.0) ?? SQL (??? ?? 4.2 x). ??? ??????? 4.2 x ?? ????? ??????? 6.0 ??? ??? ??? ?????? ????????.

4. ??????? ????????

??????? ??????? ????? ?? SQL Server 6.0 ?? ??????? ???????? ?? SQL Server 6.5:
   AUTHORIZATION     FULL      OUTER          SCHEMA
   CASCADE           INNER     PRIVILEGES     WORK
   CROSS             JOIN      RESTRICT
   ESCAPE            LEFT      RIGHT
				

????? DISTRIBUTED ?????? ?????? ????? ?? SQL Server 6.5.

??? ??? ???? ?????? ????? ???????? ???????? ?????? ?? ??? ??????? ???????? ??????? ?? ???? ????? ChkUpg65.exe.

5. FROM ????? ???? ??????

?? SQL Server 6.5 ??? ??????? ?? ????? ??? ???? ????? ??????? ??????? ?? ????? FROM. ??? ???? ??????? ???? ?????? SELECT ????? ????? ?????? ?? ????????? ??????? ??? ????? ??????? ?? SQL Server 6.5. ?? ?????? ??????? ?? ????? SELECT ?????? ?????? ??????. ?? ????? ???? ?????? ?????? ?? ????? SELECT ???????.
   SELECT * FROM pubs..authors, pubs.dbo.authors
   SELECT * FROM authors, authors
				

??????? ??????? SQL Server ??????? ??????? ?????? ?????? ?? ??? ??? ?????? ????? ????? ??? ??????. ??? ???? ??????? pubs.dbo.authors ? pubs (????????)?? ?????? ???????? ?? ????? ??????. ???? ?? ???? ??? ?????? ????? ??????? ????? ??? ?????? ?????? ????? ???????? ? ???????? ?????? ?????? ?? ??? ???? ??? ??????. ?????? ?? ????? ????? SQL Server ?????? ??? ?????? ????? ?? ???? FROM ???? ??? ??? ???? ??? ??????? ? ????? ???? ?? ?????? ?????? ???????? ?????. ???? ????? ??? ????? ?? ????????? ???? ??? ??? ????? ?? ??? ??? ???????? ??? ????? ?? ????. ????? ???? 110 ????? ??? ????? ???? ??? ?????????.

6. SELECT DISTINCT ?? ORDER

????? ????????? ??????? ?? SQL SELECT DISTINCT ??????????? ???? ????? ??? ??????? ?? ????? ?? ????? ORDER BY ?? ??? ?? ????? ???????. ??? ???? ??????:
   SELECT DISTINCT au_id FROM authors ORDER BY au_lname
				

?????? SQL Server 6.5 ?? ANSI ?????, ??? ???? ??? ??? 145:
??? ?? ???? ??????? ????? ??? ?? ??????? ??? ??? SELECT DISTINCT ??????.

????? ???? ??????? 204 ?????? ??????, ANSI (????? ?????? ??? ANSI ???? ????? ??????????? ??????? ?? SQL Server 6.0 ?????).

7. ????? ?????? ????? ????? ??? ?????

?? SQL Server 6.5 ??? ?? ????? ????? ????? ??? ???? ?? ???? ??? ?? ???? ???? ??? ????? ??? ??????; ??? ?????? ?? ANSI ????????. ?? SQL Server 6.0 ?? ??? ??? SELECT ??? ??? ?????? ???????. ????? ???? ??????? 237 ?????? ??????.

8. SELECT INTO ?? CREATE VIEW ???? ??? ??????

?? SQL Server ??????? 6.5 ? ???? ??? ?? ??? ??? ????? ?? ??? ???? ??? ???? ????? ?????? ????? SELECT INTO ?? CREATE VIEW. ??? ???? ??????? CREATE VIEW testview SELECT AS au_id ? ??????? FROM upper(au_lname) ????? ?? ????? ????? 4511:
????? ????? ????? ???? ???? ???? ????? ?? ??? ?????? ?????? 2.
??? ????? ??? ?????? ?????? ??????.

????? SQL Server 6.0 ???; ????? ???? 246 ????? ?????? ??????.

9. "???????" RAISERROR @@ ??? ??? ??? ??? ??? ??????? ???? ?? ???

???? ????? RAISERROR ???? @@ ??? ??? ??? ??? ??? ??? ??? ? 10 ????? (??????? ????? ??? ??????? 10 ? ??? ??? ????? ?????? ???? ??????? ??????). ??? ??? ?????? msg_id ???????? ???? WITH SETERROR ????? RAISERROR ?????? msg_id @@ ??? ??? ????? ?? ???????.

?? SQL Server ??????? 6.0, ??? ????? @@ ??? ??? 50.000 ??????? ?? ??????? ??????? ???? ????.

?????? ??? SQL Server ??????? 6.0 ???? ?????? ?????? SETERROR ?? ????? ???? 2701.

10. ????? ??? ???????: sp_sqlregister

??? ????? sp_sqlregister ??????? ?????? ?? SQL Server 6.5 ????????? ??? ????? ???????. ??? ??? ???????? sp_sqlregister ?????? ??????? ??????? ???????? ?? ???? ??????? ??????? SQL Server ?? ?? ???? ???? ???? SQL ??? ???? ???????. ???? ?? ???? ????? xp_sqlinventory ??? ????????? ?? ????. ???? ????? sp_unmakestartup ??????? ?????? ?????? sp_sqlregister ????????? ??????? ??? ?????.

11. ????????? ?????? ?????? ??? ?????? ????????

?? SQL Server 6.5 ???????? "?????? ??? ?????? ????????? ????? ???? ??? ?????? ???? ????? ????? ????? ??????? ???? ????????? ???? ?? ??????? ??? ??????? ????????. ???? ???????? ??????? ???? ?? ??????? 6.5 ?????? ?? ??? ??????? ???????.

????? ???? 7501 ????? ??????? ?????? ?????????? ?? ???? ??? ???? ??????? 6.0.

12. ??? ?????? ??? ?????? ??? "??????? ?????"

SQL Server 6.5 ?????? ??? ???? ?????? ?????? ??? ??? ????????? ??????? ???????; ???? ??? ????? ?? ???? ?????? ?? ?????? ??? ??????. ??? ????? ??????? ????? ??????? ?????? ??????? ???????? ??? ????? ???? ???? ??????? ??? ??? ????????? ??????? ?????? ?????? (???????). ????? ???? 7502 ?????? ????? ??? ?????? ????? ??????.

13. ???? ?????: MSDTC

??? ????? ???? ????? ?? SQL Server 6.5. ?? ???? MSDTC "???? ????????? ???????" ???? ???? ????? ??? ???? ????????? (???????? ??????? ????????). ????? ???? MSDTC ??? ?? ?? ???? ??? ????????? ???????? (??? ???????? ????????? ?????) ? ??? ??? ????? ????? ??? ??????? ???? ???????? ??? ??? ?? ???? ??? ????????? ????????. ???? ????? ?????? ??? ?????? ??? ??????.

14. ???? ????????? ?? ???? ????? EXECUTE ?? ???????

?? SQL Server 6.5 ??? ?????? EXECUTEing ????? ????? ??? ????? ??????? ????? "???????? ???????" ???? ????? ???????? ????? ??? ????? ???????? ???? ?? ??? ????????? ?? ??? ???????. ?? SQL Server 6.0 ??????? ????? "???????? ???????" ????? ??? ???????.

???? ??? ?????? ??? ?? SQL Server 6.0 ??? ?? ???? ????? ?? ????? ??? ??????? ?? ????? ???????? ????????? ?????? "?? ??????? USE ???? ????. ?? ????? ??????? ??????? "pubs (????????)" ?? SQL Server 6.0; ?? SQL Server 6.5 ?? ????? ????? "??????:"
   GO
   USE master
   GO
   DECLARE @mydb VARCHAR(30)
   SELECT @mydb = 'pubs'
   EXECUTE('USE ' + @mydb)
   go
   SELECT db_name()
   go
				

?????? ??? ???? SQL Server 6.0 ?? SQL Server 6.5 ? ??? ??????? ??????? ???????:
   GO
   USE master
   GO
   DECLARE @mydb VARCHAR(30)
   SELECT @mydb = 'pubs'
   EXECUTE('USE ' + @mydb + 'SELECT db_name()')
   go
				

???? SELECT ?? ????? ???????? ????????? ??? ?????? ???? ???? ??? ????? ???????? ???????? ??? ????????.

15. ??????? ?????? ??????? ODBC

????? ????? ????? ????? Microsoft 149921 ??? ??????? ????? ANSI ?? ?????? ????? ODBC Microsoft SQL Server 2.65.0201 ???? ?? ???? ??? ?????????. ???? ???? ??? ???? ???? ?? ???????? SET ??????? ??? ??????? ANSI:
   SET TEXTSIZE 2147483647
   SET ANSI_DEFAULTS ON
   SET CURSOR_CLOSE_ON_COMMIT OFF
   SET IMPLICIT_TRANSACTIONS OFF
				

16. JOIN ?????? ? ????? ???? 204

??? ????? ?? ????? ????? ????? ???????? * = ? = * ?? ??? ??? ????????? ??????? ?? SQL Server ? ?? ????? ??????? ?? ?? ????? ????? ??? ?????? ?????? ??? ?????? ANSI SQL ?? ??? ?????????.

??? ????? ???? ??????? 204 ???? ???? SELECT ?? ??????? 6.0 ?? SQL Server ?????????? ??????? ?????; ??????? ??????? ??????? ??????? ?????? ANSI ???? ??? ?????.

17. ???????? ??????? ?? ?????????

???? SQL Server 6.5 ???????? ??? ????? ???? ??????. ??? ???????? ????? ?? ??? ????? ??????? ????? ???? ???????? ??? ?? ??????? ??? ???? ??? ???????. ??? ????? ?? ???? ????? ???? ?? ?????? ???? ????? ???????? ???????? ??? ????? ?????? ?? ????? ???????? ??? ???????? ????? ????? ?? ???? ?????? ??? ????. ?????? ????? ??? ????? ???????? ???? ??????; ????? ??? ????? ?????? ??????? ?? ????? ?????? tempdp.

18. SELECT-INTO ??? ???? "????? ???????"

SELECT INTO ???? ????? ??????? ???? ????? ????? ????????? ????? ??? sysindexes ? sysobjects syscolumns ???? ?? SELECT-INTO ?? ?????? ??????? ???? ??????.

19. ??????? ISQL/????? ??????? ??????? ???? ??? ????? ??? ????

??? ????????? ISQL/w ??? ????? Win16 ????? ???? ????? "??? ???? ????" ?? SQL Server. ???? ?? "?????? ??? ??????" (???? ?????? 512 ????) ? ????????? ????????? ???? ???? ?? ???? ????? DB ??? ??? ?????? ??? ??????, ??? ??????? ?????? ?? ????? ?????? ??? ???? Windows 3.x. ??? ?? ????? "??? ???? ???? ???????" ??? ?????? ?? 512 ??? ?? ???? ?????? ??? ????? ??? ??? ??????? ??? ?? SQL Server 6.0 ?? ???? ???. ????? ?? ?????????? ???? ????? "????? ????? Microsoft" 150909 "INF: ??? ??????? ?????? Win16 SQL Server 6.5."

20. ??? ????? ?? ?? CHECK ? ???? DEFAULT ??????? ????????

?? ???? ??????? ????????? ???????? (??? @@ SPID ???) ?? ?????? CHECK ?? DEFAULT (?? ?????? CREATE ?? ALTER TABLE). ??? ?? ??????? ????? ????? ???? ?? ??? ??? ???? ?? ???? ???? ??? ???? ????? ??? 112:
??? ????? ????????? ?? ????? CREATE TABLE.

?????? ??????? ?????? ????? ?? ?????? ????????.

21. ????? ??? ??????: ???? ????

SQL Server 6.5 ???????? ?????? ?????? InfoView.exe ???? ???? ????? ?? MSIN32.exe ???? ?? ???????? ??????.

?? ???? ????? ?????? ???? ??? SQL Server; ???? ??????? ???? ????? ?? ???? ?????? ??? ???:
  1. ????? ???? (c:\sqlbks ????)
  2. ???? ??????? \sqlbks65\sqlbooks.* \i386\InfoView.exe ?? ????? ??????? ??? ??? ??????. ?? ???? MSIN32.EXE ?? 6.0 ??? ???? ????? 6.5 ? ????? InfoView.exe (?? ????? ?? DLLs).
  3. ????? ???? ????? ??????? ??:

    ??? ??????? ?? ???? ????? A sqlbooks.mvb c:\sqlbks\infoview.exe ?? c:\sqlbks
??? ?? ???? ?? ?????? ??? ????? ????? ???????.

22. VBSQL.vbx ??????? VBSQL.ocx

??? ?? ??? ??????? ????? Visual Basic 3.0 ?????? DB-????? 16 ?? ??????? Visual Basic VBSQL.vbx ? ??? DB-????? ??????? Visual Basic OLE ?????? ????? VBSQL.ocx. ????? ?? ?????????? ???? SQL Server 6.5 ???????? ? "????? DB-????? ????? ?? Project Visual Basic."

23. ??? ?? ????? Showplan ??????

????? ????????? ?? ????? SHOWPLAN ?????? ??????? ShowPlan ?????? ?? ??? ?????? ?? "???? ???????" ????? ??????? SQL ?? ISQL/w.

24. ??????? ????????? ????????

????? ??????? ????? ??????? ??? recompiled ?? ????????? ???????? ?????? C ????????? ???? ??????? ??????? ????? ???? ??????? C. ??? relinked ??? Microsoft SQL Server ??????? 6.5 ??? OPENDS60.LIB.

??? ????? ?? ??? ?? SQL Server 6.0 ???? ?? ??? ??????? ?????? ?? XP ??? ??? ??? ?????. ??? ?????? ??? ??????? "?????????" ?? SQL Server 6.5 ???? ??????? ???? ????????? ???? ???? ?????? ??? ????? ????? ???????? ???????? ??? ??????? ??????, ? ????? ??? ??? ???????? ???? ????? ???????.

25. ???????? ??????????

????? SQL Server 6.5 ????? ????? ??? ??? ???? ????? ??? ????? ???????. ??? ????? ?? ?? ???? ??????? ?? SQL Server 6.0 ????? ?????? ?? 6.5 ? ?? ?? ???? ????????? ?????????? ?? SQL Server ?????? ??? ??? ???? ?? ???? ??? ??????? ????? ???????? ????? ????. ??? ???? ??????? ??? ????? ?? 6.5 ??????? ??????? ??? ?? ??? ??? ?? ????????? ??????????:
  • ??? ???????: ????? ??? ?????? SELECT FOR ??????? ?? 6.5 ????? ???? FOR ??????? ?? ?????? SELECT ???? ???? ?????? ???? ???? ????? ???????? ???? ????????.
  • ?????? ?????? ??? SQL Server: ??? ?????? ??????? ????? SQL Server ????? ???????? SQL Server ? ??? ???????? ??????? ????? ???????? ????? Windows NT ?? ???????? ??? ??????? ????? ???????? ????? ?? ???.
  • ???? ??? ??????: ?? SQL Server 6.5 ' * = ' ? ' = * ' ???? ?????? ?? ??? ???? ?????? ?? ???? WHERE ???? ??????? ?? ??????? ANSI ???????? ???? ?????? ?? ????? FROM ? ????????:

    ??? ?????? ???? ??? ?????? ???? ? FULL ??? ??????.
  • ????? Quoted ?????: ??????? ????? ???????? ??? ?? ??? ???????? ???? ?? ??? ?????? ?????? ????? ??????. ??? ????? ?? ??? ?? ??? ???????? ??????? ???????? ?????? ????? ???? (????? ?? ??? ????) ? ??? SET ON QUOTED_IDENTIFIER ???????? ?? ????? ????? ?????? ?????? ???????? ???????? ??? ???? ????? ?? ???? ????.
  • ?? ????? (! =): ???? ???? ??????? ANSI ?????? '?? ?????' ?? '<>'. ??? ?? ?????? ??? ????? ?? '! = ' ?? ???? ???????.
  • ?????? ???? ????? (NULL =): ????? ANSI IS NULL ???? ??? ???????? ?? ???? ???????. ?? ??????? ??? ??? SET ON ANSI_NULLS ???? ??????? "=" NULL"????? FALSE ?? ???? ??????? ??? ????? ANSI ???? ?? ???? ???? (??? NULL ????) ?????? NULL.
  • ?????? ??????: ??? ?? ??? ??????? SQL ???? ?????? ?????? ?????? ?????? ????? ?? ??????? ???????? ?????? 4030 ? 4032.

    ???????? ??? "??????? ????????" ??? ?? ??? ??????? ???????? ?????? ????? ?????? ????????? ??? ????? ??? ??? ?? ????? ?? ????. ??? ????? ?? ?? ????? ????????? ???????? ?? ??? ???? ?????? ????? ????? ? ?? ?? ???????? ?? ???????? ?????? ???? ????? ?? ?????? ????? ????????. ???? ???? ?? ??????? ?????????? ?? ????????? ??????? ??? ?? assured.
discontinuing ??????? ??????? ??????? ????? ??? ??????:
  • ???: ????? ?? ??????? ?????? ?? ??? ???????? ??? ?????? ?? ?????? ????? ???????? ???? ??? ??? ??????? ?????? ????? ???????. ??????? ????? RAID multi-disk ???? ??? ????? ????? ???? ?? ?????? ?? ??? ????? ????? ?????.
  • DB-????? ????? ????? Two-Phase: "???? ???????" ???? ???? ???? ??? ????????? ????????.

???????

???? ???????: 152032 - ????? ??? ??????: 04/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt KB152032 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????152032

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

 

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