MASTERING SQL SERVER 2000- P25

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:1

Thêm vào BST

Báo xấu

57
lượt xem 6
download

Download Vui lòng tải xuống để xem tài liệu đầy đủ

Tham khảo tài liệu 'mastering sql server 2000- p25', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả

Chủ đề:

Bình luận(0) Đăng nhập để gửi bình luận!

Lưu

Nội dung Text: MASTERING SQL SERVER 2000- P25

WEB SERVERS • ZOOMING IN DTS PACKAGE DESIGNER 1201 Web servers, 882–883 Write a Transact-SQL Query screen, 864, 864 weeks in date functions, 170 write-ahead logs, 98, 372 weight values, 277 write conflicts, 50 Welcome screen Write File transformation, 836 Configure Publishing and Distribution Wizard, Writeback option, 1058 991, 992 WriteCompletionStatusToNTEventLog property, Copy Database Wizard, 615, 615 845 Create Database Wizard, 375, 375 WRITETEXT statement, 253–254, 1126 Create Publication Wizard, 999, 1000 wwwroot directory, 869 Create Stored Procedure Wizard, 519, 519 Create View Wizard, 473, 474 Database Maintenance Plan Wizard, 660, 660 X Index Tuning Wizard, 465, 466, 968, 968 /x argument in dtswiz, 821 Make MSX Wizard, 640, 640 X (exclusive) locks, 928 Pull Subscription Wizard, 1022, 1023 XLOCK hint, 302 Push Subscription Wizard, 1011, 1012 XML (Extensible Markup Language), 755, Upgrade Wizard, 1143, 1144 910–911, 912 Web Assistant Wizard, 861, 861 XMLData keyword, 911 When the SQL Server Data Changes option, 867 XOR operator, 160 Whenever the Job Completes option, 645 xp_cmdshell stored procedure, 533 WHERE clause, 46, 47, 190–195, 191–193, 195 xp_fileexist stored procedure, 533 with DELETE, 237–239 xp_fixeddrives stored procedure, 533 with UPDATE, 243 xp_logininfo stored procedure, 1113 wild-card datatype, 158 XSL (Extensible Style Language), 918 wild cards in Transact-SQL, 162 xsl clause, 918 Windows 2000 Internet Server Security Configura- Xslfile option, 917 tion Tool, 884 Windows Collation setting, 1138 Windows event log, 649 Y Windows NT/2000 authentication mode, 9, /y argument in dtswiz, 821 676–678, 677 YEAR function, 170 Windows NT/2000 logins, 684–687, 686–687 years in date functions, 170 WITH option Yes, Add One Hyperlink option, 872 with DELETE, 237 Yes, Display Column Names option, 871 with UPDATE, 243 Yes, Help Me Format the Web Page option, 876 WITH CUBE option, 1072–1074 Yes, Let Me Set the Distribution Database Proper- WITH ENCRYPTION option, 524, 527 ties option, 993 WITH LOG option Yes, Link the Successive Pages Together option, 874 with UPDATETEXT, 256 with WRITETEXT, 253–254 WITH MARK option, 269 Z WITH RECOMPILE option, 523 zooming in DTS Package Designer, 842 WITH ROLLUP option, 1072–1074 WITH TIES option, 216–217 Wizards page, 320 WORK keyword, 271 workflow in DTS, 818, 840–841, 841 Workflow Properties dialog box, 841, 841 workloads with Index Tuning Wizard, 15, 968–969 Workstation keyword, 734