Database Reference
In-Depth Information
Minimum SQL Grammar
CREATE TABLE, DROP TABLE
Simple SELECT (does not include subqueries)
INSERT, UPDATE, DELETE
Simple expressions (A > B + C)
CHAR, VARCHAR, LONGVARCHAR data types
Core SQL Grammar
Minimum SQL Grammar
ALTER TABLE, CREATE INDEX, DROP INDEX
CREATE VIEW, DROP VIEW
GRANT, REVOKE
Full SELECT (includes subqueries)
Aggregate functions such as SUM, COUNT, MAX, MIN, AVG
DECIMAL, NUMERIC, SMALLINT, INTEGER, REAL, FLOAT,
DOUBLE PRECISION data types
Extended SQL Grammar
Core SQL Grammar
Outer joins
UPDATE and DELETE using cursor positions
Scalar functions such as SUBSTRING, ABS
Literals for date, time, and timestamp
Figure 11-6
Summary of SQL
Conformance Levels
Batch SQL statements
Stored procedures
privileges) can use a system data source. A user data source is available only to the user
who created it.
In general, the best choice for Internet applications is to create a system data source on
the Web server. Browser users then access the Web server, which, in turn, uses the system data
source to set up a connection with the DBMS and the database.
As our first step in developing the VRGIS, we need to create a system data source for the
VRG database so that we can use it in the Web database processing application. We created
the VRG database in SQL Server 2012, and the system data source will provide a connection to
the SQL Server 20012 DBMS. To create a system data source in a Windows operating system,
you use the ODBC Data Source Administrator . 1
Opening the ODBC Data Source Administrator in Windows Server 2012
1.
Click the Start button, and then click the All Programs button.
2.
Click the Administrative Tools folder to open it.
3.
Click the Data Sources (ODBC) program.
1 Important: If you are using a 64-bit Windows operating system, be aware that there are two different ODBC Data
Source Administrator programs provided—one for 32-bit applications and one for 64-bit applications. The ODBC
Data Source Administrator used if you follow the steps in the text is the 64-bit version. However, if you are running a
32-bit program in the Web application set (e.g., a 32-bit DBMS such as the 32-bit version of SQL Server 2012 Express
Advanced), then you must use the 32-bit version of the ODBC Data Source Administrator. In the 64-bit of Windows 7,
this is the odbcad32.exe program located at C:\Windows\sysWOW64\odbcad32.exe. In Windows 8 and Windows
Server 2012, the programs are, fortunately, clearly labeled as either 32-bit or 64-bit. Nonetheless, If everything seems
to be set up correctly, yet the Web pages are not displaying properly, then this is likely to be the problem.
 
Search WWH ::




Custom Search