?? ???? ?????? UPDATE ????? ?? "?????" DELETE/INSERT

?????? ????????? ?????? ?????????
???? ???????: 238254 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

??? ??? ??? ????? ?? ???? ??? ?? ??? ???? ?? ???? SQL Server ?????? ??????? ?? "???? ?????" ? ??? ???? ??? ??? ?? DELETE / ?????? INSERT. ???? ??? "????? ???????" ????? ???????? ?????? ??? ?? DELETE / ?????? INSERT ??? ?????????. ???? ????? ??????? ?????? ???? ?? ????? ????? ???????. ????? ?? ???? ????? ??? ????? ?? UPDATE ????????? ?? ????????? ??????? ??????? ??? ??????? ??? ????? ??????? ?? DELETE / INSERT ????????? ?? ????????? ??????? ???????.

??????? ????

?????? ????????? ?? ????? ???????? ????????? ???????? ????????? ??????? ??????? INSERT ? UPDATE ? DELETE ?? ????? ????????? ?? ?????????.

??? ????? ?????? INSERT ???? ?? ??????? ?? ??? ?????? ????????? ???? ??????? ????? "INSERT ?????. ????? ???????? ??? ????? ????? DELETE ??? ??????? ????? DELETE ?????.

??? ???? ????? ??? ????? ????? UPDATE "???? ?????" ? ??????? ???? logreader ??? ?? DELETE / ??????? ??????? INSERT ??????? ?? ????? ???????? ??????? ???? ??????? ??? ????????? ????? ?? ????? ????? ??????? ???????. ??? ???? ??????? ????? ?? ???? ???? ??? ???? TABLE1 ? ?? ????? ????? ???:
  • Int col1
  • Int col2
  • col3 varchar(30).
??? ????? ??? ???? ??? ??? TABLE1 ??? col1 ???? ??? ????? ?????. ????? ?? ???? ??? ???? (1,1 ? ' ?').

????? ??? ????????? ????????:
UPDATE TABLE1 set col1 = 3 where col2 = 'Dallas'
				
??? ????? ?????? SQL Server ????? UPDATE ??? ?? DELETE / ?????? INSERT ??? ?? ???? ?????? col1 ???? ????? ??? ???? ???? ?????. ????????? logreader ???? ??? ?? DELETE / INSERT ??????? ?? ????? ???????? ???????. ??? ???? ?? ???? ?? ???? ????? ????? ???????? ?? ????????? ?? ????????? ??????? ??????? ??? ???????. ??? ????? ???? ????? ????? ?????? ?? ?????? DELETE ? INSERT ?? ????????? ??????? ??????? ??? ??????.

??? ??? ???? ??????? ???? ???? ????? ???? ??????? UPDATE ?????? ?? ????? ???????? ?? DELETE / ????? INSERT ????? ????? ????? ???? ??? ?? ???? ?? ????? "????? ??????? ?? Microsoft" ???:
160181INF: ????? ???? ??? ??? ?????? UPDATE ?? ??? DELETE/INSERT
???????? ??? ???? ??? ??? ?????? ???? ????? ???? ?? ??????? ? ??? ?? ??? ?? ?? ????? ???? ???? ????? ??? ????? ??? DELETE ???????? ????? ??? ?????????. ??? ?? ????? ???? ?? ????? ???? ???? ??????? ?????? ???? ???? ????? ??? ???????, ??? ????? ??? INSERT ????? ???????? ???? ????? ????? ????????.

?? ?????? ??????? ????? ?? ???? ????? ????? ???? ????? ??? TABLE1: ??? col2 = '?'. ?? ???? ????? ??? ????????? ????????:
UPDATE table1 set col2 = 'New York' where col1 = 3
				
logreader ???? ??????? ??? DELETE ????? ??????? ????? ???? ??????? ??? ????????? ??? ?? ?? ????? ???? ??? ??????? ?? ?????? ??????? ????.

????? ????? ????????? ???????? ???:
UPDATE table1 set col2 = 'Dallas' where col1 = 3
				
?????? logreader ??? INSERT ????? ??????? ??????? ??? ???? ?? ?????? ????? ???? ???? ???????.

??? ????? ?? ??? ?? ????? ????? UPDATE ?? ??? ?????? ? ??? ????? ??????? ???????? ??? ???????.

?????

?????? ??? SQL Server 2000 Service Pack 1 ?? ???? ???? ???? ??????? ??????? ?? "????? ??????? ?? Microsoft:
302341INF: ????? ???? ???? ??? ????? ??????? ???? ????? ????? ???????? ???????

???????

???? ???????: 238254 - ????? ??? ??????: 07/????? ??????/1429 - ??????: 6.2
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
????? ??????: 
kbmt kbinfo KB238254 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????238254

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

 

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