.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

<< < … 48 49 50 51 52 53 54 55 56 57 58 … > >>   Sort: Date

Can You Copy an Array
Can You Copy an Array? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations You can create a new array by copying an existing array using the assignment statement. Note that the new array is not a reference to the old array. If you want a reference variable pointing to the old arr... 2007-04-20, 5448👍, 0💬

Can you explain collation sequence in sql server
Can you explain collation sequence in sql server? First let’s define collation. Collation sequences are set of rules which determine how the data is sorted and compared. Sorting rules can be defined with options with case-sensitivity, accent marks, kana character types and character width. Case sens... 2007-11-02, 5447👍, 0💬

How To Get a List of All Background Sessions in the Database
How To Get a List of All Background Sessions in the Database? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't like to use a SELECT statement to get a list of all background sessions in the current database, you can use the Reports view to do this as shown in the following tutori... 2007-04-27, 5446👍, 0💬

What Happens If You Use a Wrong Connect Identifier
What Happens If You Use a Wrong Connect Identifier? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL> CONNECT fyi/retneciyf@WRONG; ... 2007-04-28, 5445👍, 0💬

What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, My... 2007-05-11, 5444👍, 0💬

What Happens If NULL Values Are Involved in Expressions
What Happens If NULL Values Are Involved in Expressions? - MySQL FAQs - Introduction to SQL Basics If NULL values are used in expressions, the resulting values will be NULL values. In other words: Arithmetic expressions with NULL values result NULL values. Comparison expressions with NULL values res... 2007-05-11, 5444👍, 0💬

How to Accessing HTML Elements using javascript?
How to Accessing HTML Elements using javascript? To do something interesting with HTML elements, we must first be able to uniquely identify which element we want. In the example below: &lt;body> &lt;form action=""> &lt;input type="button" id="useless" name="mybutton" value="doNothing" />... 2008-09-23, 5442👍, 0💬

How To Delete a Column in an Existing Table
How To Delete a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL> CREATE TABLE emp_dept_90 2 AS... 2007-05-03, 5442👍, 0💬

Can we post and access view state in another application
Can we post and access view state in another application? You can post back to any page and pages in another application, too. But if you are posting pages to another application, the PreviousPage property will return null. This is a significant restriction, as it means that if you want to use the v... 2007-10-23, 5441👍, 0💬

How To Use Different Markers on Unordered List Items
How To Use Different Markers on Unordered List Items? - XHTML 1.0 Tutorials - Understanding Lists and List Items By default, browsers will use solid dots as the item markers for unordered lists. If you want to change them to something else, like tiny squares, you need to use CSS properties. Here is ... 2007-05-11, 5441👍, 0💬

How To Turn on Query Logs
How To Turn on Query Logs? - MySQL FAQs - Server Daemon mysqld Administration If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log f... 2007-05-11, 5441👍, 0💬

How To Access MySQL Servers through Firewalls
How To Access MySQL Servers through Firewalls? - MySQL FAQs - PHP Connections and Query Execution If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MyS... 2007-05-10, 5441👍, 0💬

Can the Query Output Be Sorted by Multiple Columns
Can the Query Output Be Sorted by Multiple Columns? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL> SELEC... 2007-04-20, 5441👍, 0💬

Which is the best place to store connectionstring in .NET projects
Which is the best place to store connectionstring in .NET projects ? Config files are the best places to store connectionstrings. If it is a web-based application “Web.config” file will be used and if it is a windows application “App.config” files will be used. 2007-10-24, 5439👍, 0💬

What Are NULL Values
What Are NULL Values? - MySQL FAQs - Introduction to SQL Basics NULL is a special value that represents no value. Here are basic rules about NULL values: NULL presents no value. NULL is not the same as an empty string ''. NULL is not the same as a zero value 0. NULL can be used as any data type. NUL... 2007-05-11, 5439👍, 0💬

How To Delete an Existing Row from a Table
How To Delete an Existing Row from a Table? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: INSERT INTO fyi_links (url, id) VAL... 2007-04-21, 5439👍, 0💬

What Are the Restrictions in a READ ONLY Transaction
What Are the Restrictions in a READ ONLY Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management There are lots of restrictions in a READ ONLY transaction: You can not switch to READ WRITE mode. You can not run any INSERT, UPDATE, DELETE statements. You can run SELECT query statemen... 2007-04-17, 5439👍, 0💬

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures? ADO.NET provides the SqlCommand object which provides the functionality of executing stored procedures. Note :- Sample code is provided in folder “WindowsSqlClientCommand”. There are two stored proce... 2007-10-24, 5438👍, 0💬

How To Move Uploaded Files To Permanent Directory
How To Move Uploaded Files To Permanent Directory? - PHP Script Tips - Uploading Files to Web Servers PHP stores uploaded files in a temporary directory with temporary file names. You must move uploaded files to a permanent directory, if you want to keep them permanently. PHP offers the move_uploade... 2007-04-19, 5438👍, 0💬

Extract a specific attribute from an element using XSLT
Using XSLT, how would you extract a specific attribute from an element in an XML document? Successful candidates should recognize this as one of the most basic applications of XSLT. If they are not able to construct a reply similar to the example below, they should at least be able to identify the c... 2007-04-11, 5438👍, 0💬

How To Rename a Column in an Existing Table
How To Rename a Column in an Existing Table? - Oracle DBA FAQ - Managing Oracle Database Tables Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statem... 2007-05-03, 5437👍, 0💬

How To Create a Table Interactively
How To Create a Table Interactively? - Oracle DBA FAQ - Introduction to Oracle SQL Developer If you don't want to use SQL statements to create a new table, you use SQL Developer to create one interactively. Follow the steps below to create a new table called: TIP Right-click on the Tables in the obj... 2007-04-27, 5437👍, 0💬

What Are Sub-elements of the entry Element
What Are Sub-elements of the entry Element? - RSS FAQs - Atom Feed File Structure and Elements The "entry" element has the following sub-elements defined: &lt;author&gt; - Specifying the personal information about an author of the contents provided in this feed entry. A feed element may have... 2007-05-12, 5435👍, 0💬

How To Remove Values Saved in the Current Session
How To Remove Values Saved in the Current Session? - PHP Script Tips - Understanding and Using Sessions If you want to remove values saved in the current session, you should use the unset() function on those saved values in $_SESSION, or use array() to empty $_SESSION: unset($_SESSION['MyColor']) - ... 2007-04-17, 5435👍, 0💬

<< < … 48 49 50 51 52 53 54 55 56 57 58 … > >>   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