.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 64 65 66 67 68 69 70 71 72 73 74 … > >>   Sort: Date

How To Connect to MySQL Server on a Different Port
How To Connect to MySQL Server on a Different Port? - MySQL FAQs - Server Daemon mysqld Administration If your MySQL server is listening on port number different than 3306, you need to specify "--port=portNumber" option to any client program that needs to connect to the server. The tutorial exercise... 2007-05-11, 5136👍, 0💬

How To Create an Oracle Database
How To Create an Oracle Database? - Oracle DBA FAQ - Creating New Database Instance Manually There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually. 2007-04-22, 5136👍, 0💬

What Are DDL Statements
What are the most important DDL statements in SQL? CREATE TABLE - creates a new database table ALTER TABLE - alters (changes) a database table DROP TABLE - deletes a database table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index 2007-04-15, 5136👍, 0💬

What does the EnableViewStateMac setting in an aspx page do?
What does the EnableViewStateMac setting in an aspx page do? Setting EnableViewStateMac=true is a security measure that allows ASP.NET to ensure that the viewstate for a page has not been tampered with. If on Postback, the ASP.NET framework detects that there has been a change in the value of viewst... 2008-09-23, 5135👍, 0💬

What are the various objects in Dataset
What are the various objects in Dataset ? Dataset has a collection of DataTable object within the Tables collection. Each DataTable object contains a collection of DataRow objects and a collection of DataColumn objects. There are also collections for the primary keys, constraints, and default values... 2007-10-24, 5135👍, 0💬

How can we call methods in remoting Asynchronously
How can we call methods in remoting Asynchronously All previous examples are a synchronous method calls that means client has to wait until the method completes the process. By using Delegates we can make Asynchronous method calls. 2007-10-23, 5135👍, 0💬

Processing HTML Form Date
Can a JSP page process HTML FORM data? Yes. However, unlike servlets, you are not required to implement HTTP-protocol specific methods like doGet() or doPost() within your JSP page. You can obtain the data for the FORM input elements via the request implicit object within a scriptlet or expression a... 2007-04-03, 5135👍, 0💬

How To Convert Character Strings to Numeric Values
How To Convert Character Strings to Numeric Values? - MySQL FAQs - Introduction to SQL Basics You can convert character strings to numeric values by using the CAST(string AS DECIMAL) or CAST(string AS SIGNED INTEGER) function as shown in the following examples: SELECT CAST('4123.45700' AS DECIMAL) F... 2007-05-11, 5134👍, 0💬

How To Uploaded Files to a Table
How To Uploaded Files to a Table? - PHP Script Tips - Uploading Files to Web Servers To store uploaded files to MySQL database, you can use the normal SELECT statement as shown in the modified processing_uploaded_files.php listed below: &lt;?php $con = mysql_connect("localhost", "", ""); mysql_s... 2007-04-19, 5134👍, 0💬

what is a service class
what is a service class? 2007-11-04, 5133👍, 0💬

What is Tracing in ASP.NET
What is Tracing in ASP.NET ? Tracing allows us to view how the code was executed in detail. 2007-10-24, 5133👍, 0💬

What are two different types of remote object creation mode in .NET
What are two different types of remote object creation mode in .NET ? There are two different ways in which object can be created using Remoting :- ã SAO (Server Activated Objects) also called as Well-Known call mode. ã CAO (Client Activated Objects) SAO has two modes gSingle Callh and gSing... 2007-10-23, 5133👍, 0💬

What Is the Author META Tag/Element
What Is the Author META Tag/Element? - XHTML 1.0 Tutorials - Document Structure and Head Level Tags The author meta element is a special meta element that provides information about the author of the XHTML document. The author meta element must include the "name" attribute as, name="author". Here is... 2007-05-12, 5133👍, 0💬

What is LOCK escalation
What is LOCK escalation? Lock escalation is the process of converting of low level locks (like row locks, page locks) into higher level locks (like table locks). Every lock is a memory structure too many locks would mean, more memory being occupied by locks. To prevent this from happening, SQL Serve... 2007-10-25, 5132👍, 0💬

How To Insert Data into an Existing Table
How To Insert Data into an Existing Table? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts If you want to insert a row of data into an existing table, you can use the INSERT INTO statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql ... 2007-05-10, 5132👍, 0💬

What Is the Quickest Way to Export a Table to a Flat File
What Is the Quickest Way to Export a Table to a Flat File? - Oracle DBA FAQ - Loading and Exporting Data The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following ... 2007-04-30, 5132👍, 0💬

What Are Data Types Limitations
What Are Data Types Limitations? Max. columns in a table is 255. Max. Char size is 255, Long is 64K and Number is 38 digits. Cannot Query on a long column. Char, Varchar2 Max. size is 2000 and default is 1 byte. Number(p,s) p is precision range 1 to 38, s is scale -84 to 127. Long Character data of ... 2007-04-15, 5132👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query. 2007-10-25, 5131👍, 0💬

What’s the difference between Cache object and application object
What’s the difference between Cache object and application object ? The main difference between the Cache and Application objects is that the Cache object provides cache-specific features, such as dependencies and expiration policies. 2007-10-23, 5131👍, 0💬

How To Write a Query with a Left Outer Join
How To Write a Query with a Left Outer Join? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries If you want to query from two tables with a left outer join, you can use the LEFT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a left outer join from two... 2007-05-11, 5131👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - MySQL FAQs - PHP Connections and Query Execution The first thing after you have created a connection object to the MySQL server is to select the database where your tables are located, by using the mysql_select_db() function. If your MySQL server is offered by yo... 2007-05-10, 5131👍, 0💬

What To Do If the StartBD.bat Failed to Start the XE Instance
What To Do If the StartBD.bat Failed to Start the XE Instance? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition If StartBD.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not b... 2007-04-24, 5131👍, 0💬

How To Write a String to a File without a File Handle
How To Write a String to a File without a File Handle? - PHP Script Tips - Reading and Writing Files If you have a string, want to write it to a file, and you don't want to open the file with a file handle, you can use the file_put_contents(). It opens the specified file, writes the specified string... 2007-04-23, 5131👍, 0💬

What Happens to the Current Transaction If the Session Is Killed
What Happens to the Current Transaction If the Session Is Killed? - Oracle DBA FAQ - Understanding SQL Transaction Management If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be rem... 2007-04-18, 5131👍, 0💬

<< < … 64 65 66 67 68 69 70 71 72 73 74 … > >>   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML