Có 80+ tài liệu thuộc chủ đề "giáo trình sql cơ bản"
tailieu.vn Xem trực tuyến Tải xuống
ADOMD.NET Object Model. It can also be used to connect to the multidimensional data source metadata, for example, a local cube (.cub) file. Unlike objects of most other ADOMD.NET classes that are instantiated by calling the constructor, objects created from the AdomdDataReader class are instantiated by calling the ExecuteReader method of the AdomdCommand object.. The AdomdDataAdapter class is responsible for...
tailieu.vn Xem trực tuyến Tải xuống
Using SMO with VB.NET or any other .Net language, you can create custom SQL Server management interfaces that let you perform all the functions SQL Server’s Management Studio provides. In fact, SMO is the foundation for SQL Server’s Management Studio. SQL Server’s SMO functions can be used by a programming language that is supported by the Common Language Runtime (CLR),...
tailieu.vn Xem trực tuyến Tải xuống
This list represents only the major objects in the SMO JobServer object hierarchy. In the first part of this chapter, you had an overview of SMO objects, followed by an explanation of some of the most important SMO collections, methods, and properties. In the next part of the chapter, you learn how you can put SMO to work in a...
tailieu.vn Xem trực tuyến Tải xuống
Here you can see how the sqlcmd command is executed to start the sqlcmd command shell. Microsoft (R) SQL Server Command Line Tool Version NT INTEL X86. Listing SQL Server Systems: –L. Use the –L switch to list all of the registered SQL Server systems, as is shown here:. SQL Server System/Instance: –S. You can use the –S switch to...
tailieu.vn Xem trực tuyến Tải xuống
connecting to SQL Server, 265–281 connecting to SQL Server using a UDL. connecting to SQL Server using the Data Link dialog, 277–281 connection string keywords, 266 data bound Recordsets, 295–298 error handling, 318–320. Generate SQL Server Scripts Wizard, 5, 7, 8 GROUP BY clause, 53–54. Microsoft Full-Text Engine for SQL Server (MSFTESQL), 48–49. provider-specific keywords, 267–268 OLE DB Provider for...
tailieu.vn Xem trực tuyến Tải xuống
1516922 FM.F AM Page i. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization...
tailieu.vn Xem trực tuyến Tải xuống
The MySQL Web page is displayed.. B efore you can use MySQL, you need a working MySQL server. If you do not already have access to one, you can download the MySQL software from the MySQL Web site, www.mysql.com/, and install it on a computer running UNIX, Windows, or another supported operating system. To access the downloadable files, click the...
tailieu.vn Xem trực tuyến Tải xuống
You are returned to the MySQL monitor.. The Windows version of the MySQL monitor does not support the. This utility includes a text box that you can use to enter a command of any length, and then submit it to the server. While there are slight differences in the client programs, they use the same protocols to communicate with the...
tailieu.vn Xem trực tuyến Tải xuống
The table is now created.. You can always change the length later. This starts the table definition.. You can use these columns whenever you need to assign categories to the items in a table. the table. Because ENUM and SET columns can have a large number of possible values, you may need to split the column specification into two or...
tailieu.vn Xem trực tuyến Tải xuống
MySQL now changes the name of the column.. If you change the column order using ALTER TABLE, it may create potential problems with applications that were built to work with the table. This command adds a row to the table, specifying values for each of the three columns. If you have changed the column order using the CHANGE or ADD...
tailieu.vn Xem trực tuyến Tải xuống
The rows of the table are displayed. You can use the SELECT keyword with INSERT to copy one or more rows from one table to another. In this example, all of the rows of the address table are copied. If the field names for two tables are the same, you can use a wildcard to copy all of the fields:....
tailieu.vn Xem trực tuyến Tải xuống
All of the. The values of the columns you specified are displayed for all rows. If you want to update a row and preserve the current value of the timestamp column, you must explicitly set the column to its original value.. You can also set the timestamp column explicitly to a different value. When a new test is administered to...
tailieu.vn Xem trực tuyến Tải xuống
When you use GROUP BY, you can select any number of columns as well as functions such as COUNT and AVG that aggregate the data from the grouped rows. Note: This example uses the quotes table, which you can import from the CD-ROM, and creates a new authors table.. M ySQL is known as a relational database system, and one...
tailieu.vn Xem trực tuyến Tải xuống
The following query searches the values of the quote column in the quotes table for the string "every". This function is similar to LOCATE, but the parameters are in the opposite order: you first specify the larger string, and then the substring to search for. If you need to know the current date within a MySQL query, you can use...
tailieu.vn Xem trực tuyến Tải xuống
This utility supports the same -u and -p options as the mysql command. You can use the >. From the MySQL monitor, type USE testdb. To use the file, you can simply route it through the mysql command to process the SQL statements.. The following example uses the mysql command to restore the database backed up in the db.txt file:....
tailieu.vn Xem trực tuyến Tải xuống
MANAGE THE MYSQL SERVER 9. For example, if you want to display a list of MySQL variables and their current values, you can use several commands: show variables from the MySQL monitor, mysqladmin variables from the command prompt, the Variables tab in WinMySQLadmin , or the Show variables button in MySQLGUI.. You can use whichever commands are available to you,...
tailieu.vn Xem trực tuyến Tải xuống
You can use MySQL commands to create users and grant them privileges for a database or table.. This database is created when you install the MySQL server. When you install the MySQL server, the root user is created by default. If the user does not already exist, it is created.. If you are the administrator of the MySQL server, you...
tailieu.vn Xem trực tuyến Tải xuống
The MySQL server's current process list is displayed.. When you select the Users option, the user table in the mysql database is opened, and the list of current users is displayed. You can also open the mysql database directly in phpMyAdmin to work with the various security tables. if you mistakenly delete the root user, for example, you can lose...
tailieu.vn Xem trực tuyến Tải xuống
You can choose to install these modules within the Setup Wizard when you are installing ActivePerl. You can download Apache for Windows from the Apache Software Foundation's Web site: www.apache.org/.. As with the UNIX version of Apache, you can install the mod_perl module to directly support Perl scripts from within the Web server.. Type tar zxf followed by the name...
tailieu.vn Xem trực tuyến Tải xuống
Specify a table name and optionally one or more of the keywords QUICK, FAST, CHANGED, MEDIUM, or EXTENDED.. This command resets most of the status variables that are shown with the SHOW STATUS command. This command stops a thread on the MySQL server.. The GRANT command grants one or more privileges to a user of the MySQL server. The REVOKE...