????? ??????? Self-Paced MCITP (???????? 70 442): ????? ??????? ?????? ???????? ?? ???? ??????? Microsoft SQL Server 2005 ????????? ????????

?????? ????????? ?????? ?????????
???? ???????: 937632 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ??? ??????? ??? ??????? ????????? ???????? ??? ????? ???????? ???????? ???? Microsoft Press ?????? ??????? Self-Paced MCITP (???????? 70 442): ????? ??????? ?????? ???????? ?? ???? ??????? Microsoft SQL Server 2005 ? 978-0-7356-2383-5.

??? ????? ???????? ???????:

  • 14 ??????: ??? ????? ?? ????? ????????? ???????? SqlConnection
  • 29 ??????: ??? ?? ???? SQL.GetProducts SQL.GetEngineeringList
  • 85 ??????: ????? ?????? ?????? ??? ??????? ?????
  • ????? 110 & 111: "production.product" ??? ?? ???? "Production.Product"

??????? ????

14 ??????: ??? ????? ?? ????? ????????? ???????? SqlConnection

?? ?????? 14 ? ??? ?????? ??? ????? ?????? ?? ????? ????????? ???????? SqlConnection ??? ????? ?????.

?????:
sqlConn = new SqlConnection(connString);

???:
SqlConnection sqlConn = new SqlConnection(connString);


29 ??????: ??? ?? ???? SQL.GetProducts SQL.GetEngineeringList

?? ?????? 29 ????? ?????? ?? ????? ????????? ???????? C# ?????? 11 ????? ??? ????? ????? ??? ??? ????.

?????:
SQL.GetProducts ws = new SQL.GetEngineeringList();


???:
SQL.GetEngineeringList ws = new SQL.GetEngineeringList();


85 ??????: ????? ?????? ?????? ??? ??????? ?????

?? ?????? 85 ??? 16 ?? ???????? ??????? ?? ????? ????????? ???????? ?? ?????? ????? ??? ???? ?????.

?????:
WHERE pm.Instructions.value('(AW:root/AW:Location/@LocationID[1]', 'int')= @LocID

???:
WHERE pm.Instructions.value('(AW:root/AW:Location/@LocationID)[1]', 'int')= @LocID

????? 110 & 111: "production.product" ??? ?? ???? "Production.Product"

?? ?????? 110 & 111 ?? ????????? ???????? ??? VB ? C# ?????? ????? ????????? ??? ????.

????? ?????? C# ??:
String queryString = "select * from production.product";

???:
String queryString = "select * from Production.Product";

????? ?????? VB ??:
Dim queryString As String = "select * from production.product"

???:
Dim queryString As String = "select * from Production.Product"

????? Microsoft Press ??? ????? ????? ??? ??????? ??????. ???? ????????? ?????????? ????????? ???????? ????? ?????? ???????? ?? printings ?????????? ?? ??? ??????. ??? ??? ???? ????? ???? ?? ??? ?????? ?? ????? ?????? ??? ???? ?? ???? ????????? ?????.

???????

???? ???????: 937632 - ????? ??? ??????: 06/????? ??????/1428 - ??????: 1.3
????? ???
  • MCITP Self-Paced Training Kit (Exam 70-442): Designing and Optimizing Data Access by Using Microsoft SQL Server 2005, ISBN 0-7356-2383-X
????? ??????: 
kbmt KB937632 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????937632

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

 

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