<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date

How To Use SELECT Statement to Count the Number of Rows
How To Use SELECT Statement to Count the Number of Rows? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good example: mysql> SELECT COUNT(*) FROM ...
2007-05-11, 5389👍, 0💬

How To Submit Values without a Form
How To Submit Values without a Form? - PHP Script Tips - Processing Web Forms If you know the values you want to submit, you can code the values in a hyper link at the end of the URL. The additional values provided at the end of a URL is called query string. There are two suggestions on how to use q...
2007-04-22, 5389👍, 0💬

What Is File Upload
What Is File Upload? - PHP Script Tips - Uploading Files to Web Servers File upload is Web page function which allows visitor to specify a file on the browser's system and submit it to the Web server. This is a very useful function for many interactive Web sites. Some examples are: Web base email sy...
2007-04-19, 5389👍, 0💬

What Is a Dead Lock
What Is a Dead Lock? - Oracle DBA FAQ - Understanding SQL Transaction Management A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create loc...
2007-04-17, 5389👍, 0💬

What is black box testing and White box testing
What is black box testing and White box testing? Black box testing is also termed as functional testing. It ignores how the internal functionality of a system works and depends only what are the outputs on specified inputs. Source code availability is not an important in back box testing. Black box ...
2007-10-30, 5388👍, 0💬

How To Use NULL as Conditions
How To Use NULL as Conditions? - Oracle DBA FAQ - Understanding SQL Basics If you want to compare values against NULL as conditions, you should use the "IS NULL" or "IS NOT NULL" operator. Do not use "=" or "&lt;>" against NULL. The sample script below shows you some good examples: SELECT 'A' IS...
2007-04-23, 5388👍, 0💬

What is impersonation in ASP.NET
What is impersonation in ASP.NET ? By default, ASP.NET executes in the security context of a restricted user account on the local machine. Sometimes you need to access network resources such as a file on a shared drive, which requires additional permissions. One way to overcome this restriction is t...
2007-10-24, 5387👍, 0💬

What Is a DIV Tag/Element
What Is a DIV Tag/Element? - XHTML 1.0 Tutorials - Understanding DIV and SPAN elements A "div" element is a block element that you can use a container of flow elements (flow elements are really the superset of both inline elements and block elements). By default, "div" elements will be treated as pa...
2007-05-12, 5386👍, 0💬

What are the steps to create a webservice and consume it
What are the steps to create a webservice and consume it ? Note :- For this question this book will make a attempt by creating a simple webservice and explaining steps to acheive it. A simple webservice will be created which takes two number and gives addition result of the two number. In CD sample ...
2007-10-23, 5385👍, 0💬

What Happens If Unique Value Constraints Are Violated
What Happens If Unique Value Constraints Are Violated? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements If you are inserting a new record that has values violating a unique constraint, you will get an error. Note that primary key column has a unique value constraint by default. ...
2007-05-11, 5384👍, 0💬

How To Pass Parameters to Procedures
How To Pass Parameters to Procedures? - Oracle DBA FAQ - Introduction to PL/SQL Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQ...
2007-04-26, 5384👍, 0💬

What is Maximum Pool Size in ADO.NET Connection String
What is Maximum Pool Size in ADO.NET Connection String?
2007-10-24, 5383👍, 0💬

How To Delete an Existing Rows in a Table
How To Delete an Existing Rows in a Table? - PHP Script Tips - Working with MySQL Database If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_connection.php"; $sq...
2007-04-14, 5383👍, 0💬

How To Rebuild an Index
How To Rebuild an Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME T...
2007-04-27, 5382👍, 0💬

How To Update a Table Row with a Record
How To Update a Table Row with a Record? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample sc...
2007-04-26, 5381👍, 0💬

Declaring Methods within JSP Pages
How can I declare methods within my JSP page? You can declare methods for use within your JSP page as declarations. The methods can then be invoked within any other methods you declare, or within JSP scriptlets and expressions. Do note that you do not have direct access to any of the JSP implicit ob...
2007-04-03, 5381👍, 0💬

Can You Add Values to an Array without a Key
Can You Add Values to an Array without a Key? - PHP Script Tips - Understanding PHP Arrays and Their Basic Operations Can You Add Values to an Array with a Key? The answer is yes and no. The answer is yes, because you can add values without specifying any keys. The answer is no, because PHP will add...
2007-04-20, 5379👍, 0💬

What Is Atom 1.0 Standard
What Is Atom 1.0 Standard? - RSS FAQs - Atom Feed Introduction and File Generation Atom is an XML-based document format that describes lists of related information known as "feeds". Feeds are composed of a number of items, known as "entries", each with an extensible set of attached metadata. For exa...
2007-05-12, 5378👍, 0💬

What is Modeling and why UML ?
What are advantages of using UML? As the name suggest UNIFIED MODELING LANGUAGE. Modelling has been around for years, not only in software field but also in other trades like civil, mechanical etc. Example in civil engineering drawing the main architecture built of diagram is a model by itself. Mode...
2007-10-26, 5377👍, 0💬

What Is SQL*Plus
What Is SQL*Plus? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iS...
2007-04-28, 5377👍, 0💬

What are Daemon threads and how can a thread be created as
What are Daemon threads and how can a thread be created as Daemon? Daemon thread's run in background and stop automatically when nothing is running program. Example of a Daemon thread is "Garbage collector". Garbage collector runs until some .NET code is running or else its idle. You can make a thre...
2007-10-22, 5376👍, 0💬

How To Break a File Path Name into Parts
How To Break a File Path Name into Parts? - PHP Script Tips - Working with Directoris and Files If you have a file name, and want to get different parts of the file name, you can use the pathinfo() function. It breaks the file name into 3 parts: directory name, file base name and file extension; and...
2007-04-23, 5375👍, 0💬

What Is NULL
What Is NULL? - Oracle DBA FAQ - Understanding SQL Basics NULL is a special value representing "no value" in all data types. NULL can be used on in operations like other values. But most opertations has special rules when NULL is involved. The tutorial exercise below shows you some examples: SET NUL...
2007-04-23, 5375👍, 0💬

How to use a checkbox in a datagrid
How can I track event in checkbox which is one of the columns of a datagrid ? Note: - This is normally asked when the interviewer want to see that have you really worked practically on a project. Following are the steps to be done :- 1. In ASPX page you have to add Itemtemplate tag in datagrid. &...
2007-10-24, 5374👍, 0💬

<< < 43 44 45 46 47 48 49 50 51 52 53 > >>   Sort: Date