A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.

Why am I being blocked by spid -1? I am not able to kill it and have to restart SQL Server to get around it. Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Private Sub ddlCulture_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlCulture.SelectedIndexChanged

Include EXPLAIN command in the embedded dynamic SQL statements 52.How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

Many users attempt to alias SQL statements or clauses like this: 1> \alias nrows="SELECT COUNT(*) FROM *!" 1> nrows syscolumns; sqsh: Invalid command however it is stated in the manual page that \alias only applies to aliasing other sqsh commands. The above problem can be expressed using environment variables as: 1> \set nrows="SELECT COUNT(*) FROM" 1> $nrows syscolumns; This problem is covered extensively in README.SGI supplied with the sqsh distribution.

JavaTM runtimes are available from Sun, IBM plus other vendors. Sun provides Java runtimes for Win32, Solaris and Linux from their website at http://www.javasoft.com/j2se/. IBM also provides various Java runtimes for a number of platforms at http://www.ibm.com/java/jdk/download/.

A script with SQL or SQL*Plus commands in it should have the extension ".sql". E.g. your script is called "foo.sql" to run it type "start foo" or "start foo.sql".

Where n is an integer, and word is an alpha-numeric identifier (or number). When the placeholder is associated with a number, that number identifies the index of the bind variable to replace it with. When it is an identifier, it identifies the name of the correponding bind variable. (In the instance of the first format—a single question mark—the placeholder is assigned a number one greater than the last index used, or 1 if it is the first.

When you got the error you got a SQL state code. Type ? and the code to get more information on the error.

Before you Execute the PL/SQL do the following: SQL> set serveroutput on SQL> execute xxxxxxxxxxxxxx.xxxxxxxxxxx; dont forget the semicolon CREATE OR REPLACE PACKAGE BODY apps_ar_forms_dup_trackcm AS select line, text from user_source where upper(name) = upper('&PLSQL_NAME') order by line Click Database, then Schema Browser, wait a few minutes. Then click the PROCS tab and look for your FUNCTION, PROCEDURE or PACKAGE. click here for a screen print example

Yes, you can install multiple instances of both server versions on the same machine. At least one of them has to be installed as a named instance. For a default instance, the default port is 1433. For a named instance, it is dynamic but you could configure it as fixed port. Applications querying a SQL Server by IP number will be directed to the default instance. Applications should always query the SQL server to get the dynamic port of a named instance, and then connect to that instance.

Yes, run the ???Query Optimizer??? report. It will provide you with different statistics including the use of hints (i.e. table, join, plan, etc.)

There are several freely available tools on the internet that allow you to set up a Java application as an NT service. See the following links;

UDB Further databases can be added, depending on customer requirements. CANAM would like to take this opportunity to thank the current customers for their help in supplying technical information to enable us to support the above databases.

Do an explain on the statement or program which will give details as to the access path the optimizer has chosen.

Is it possible to write a trigger referencing more than one table - I want a trigger to audit a master/detail pair. Is it possible to easily convert existing SQL scripts into a format that cannot be read or altered? This is to improve security on an existing site.

If you do not want to use SQL Studio, you can also open an SQL session with the sqlcli tool: sqlcli -u <database_user>,<database_user_password> -d <database_name>, e.g. sqlcli -u MONA,RED -d DEMODB. A complete list of options can be obtained by executing sqlcli -h. # sqlcli -u MONA,RED -d DEMODB Welcome to the MaxDB interactive terminal.

The semi colon is only used to end a multi-line SQL command. The Oterro engine does not support multi-line commands. All you should need to do if you are accessing a database through an ODBC connection is to replace the database name in the connect string. When using DAO or RDO controls, you would replace the database name with an ODBC connection to the Oterro database.

Use back-ticks to refer to the column names and then alias them so you can refer to them as something else: SELECT 'First Name' AS FirstName, 'Last-Name' AS LastName, PhoneExtension FROM Employees ORDER BY 'Last Name', 'First Name'

Statements including group functions impact performance. Use a WHERE clause to exclude unwanted rows. HAVING should only be used with an aggregate condition. Inappropriate use of the HAVING clause increases response time. READ_MODULE reads the last module and action names set by SET_ACTION or SET_MODULE. READ_CLIENT_INFO reads the last client information set for the session.

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Private Sub ddlCulture_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlCulture.SelectedIndexChanged Answer :You would get this error if the application mappings for ASP.NET file name extensions (such as .aspx) are not configured correctly in Microsoft Internet Information Services (IIS). To resolve this go to C:\Windows Directory\Microsoft.

Check to see if any ACCESS 97 reserved word is used as item/table, e.g. date. If so, either go back to the model (SER or OER) to change it and rerun from there, or change through an editor. In "Open Database" window, change directory to IBMS homepage directory, choose "COMPSQL.MDB", and click "Ok". The "Convert/Open Database" windows will appear, mark "Convert Database" option and click "Ok".

A driver for the database of your choice, e.g., Oracle, MySQL [all drivers from ActualTechnologies] Then, do the following: Lane Webcast class: Learning SQL to Query Biological Databases. 80% of users who took this class would recommend it to a colleague. Excellent book describing how to run SQL queries via Excel, and returning results to Excel: Excel advanced report development, Timothy Zapawa, 2005.

Yes, provided that the web application using the database has been tested for scalability on that server. For information about scaling IIS, including information about adjusting IIS queue and cache settings and how to scale IIS with centralized UNC content storage, see Web Server Scalability in the Internet Information Services (IIS) 6.0 Resource Guide.

A.10 Yes. MSDE can be installed and run together with a "full version" of SQL without any modification or issues.

Yes. The instructions in the Installation Guide won't apply to Unix, however, but an experienced DBA should have no trouble setting up the system.

No. The Oracle8i or SQL Server 2000 database server requires Windows NT. (Neither Oracle nor Microsoft produce a database server for Mac OS). Yes. The Clients & Profits SQL CD includes installers for Windows 95/98/Me, Windows NT/2000/XP, and Mac OS 9 (the application will run as a "classic" application in Mac OS X), . The Oracle8i client software for Windows is included on the Oracle CD; the Mac client software is provided on CD upon request from Oracle.

Yes, it is possible to do this. In the case of multiple storage nodes, each node must use a different data directory. If you want to run multiple SQL nodes on one machine, then each instance of mysqld must use a different TCP/IP port.