.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

<< < … 53 54 55 56 57 58 59 60 61 62 63 … > >>   Sort: Date

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, 5244👍, 0💬

What Are Date and Time Functions
What Are Date and Time Functions? - MySQL FAQs - Introduction to SQL Date and Time Handling MySQL offers a number of functions for date and time values: ADDDATE(date, INTERVAL expr unit) - Adding days to a date. Same as DATE_ADD(). ADDTIME(time1, time2) - Adding two time values together. CURDATE() -... 2007-05-11, 5242👍, 0💬

How Do You If a Key Is Defined in an Array
How Do You If a Key Is Defined in an Array? - PHP Script Tips - PHP Built-in Functions for Arrays There are two functions can be used to test if a key is defined in an array or not: array_key_exists($key, $array) - Returns true if the $key is defined in $array. isset($array[$key]) - Returns true if ... 2007-04-20, 5242👍, 0💬

What are the element in State Chart diagrams
What are the element in State Chart diagrams ? State: Itfs a condition when following events occur: bject satisfies a condition. Or performs a action. Or waits for a event to happen. Composite State : It has one or more sub states. Initial State: It represents a state before any event occurs. Final... 2007-10-26, 5241👍, 0💬

Where Are the Session Values Stored
Where Are the Session Values Stored? - PHP Script Tips - Understanding and Using Sessions When a value is saved into the current session by one PHP page, the PHP engine must stored this value somewhere on Web server, so that the PHP engine can retrieve it back when same visitor comes back to request... 2007-04-18, 5241👍, 0💬

What is marshalling and what are different kinds of marshalling ?
.NET INTERVIEW QUESTIONS - What is marshalling and what are different kinds of marshalling ? Marshaling is used when an object is converted so that it can be sent across the network or across application domains. Unmarshaling creates an object from the marshaled data. There are two ways to do marsha... 2009-09-15, 5240👍, 0💬

What Is "mysqldump"
What Is "mysqldump"? - MySQL FAQs - Administrator Tools for Managing MySQL Server "mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump": "mysqldump databaseName tableName" - Dumps the spe... 2007-05-11, 5240👍, 0💬

How To Replace a Substring in a Given String
How To Replace a Substring in a Given String? - PHP Script Tips - PHP Built-in Functions for Strings If you know the position of a substring in a given string, you can replace that substring by another string by using the substr_replace() function. Here is a PHP script on how to use substr_replace()... 2007-04-21, 5239👍, 0💬

What is Program Global Area (PGA)
What is Program Global Area (PGA)? - Oracle DBA FAQ - Oracle Basic Concepts A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies t... 2007-04-21, 5239👍, 0💬

How to access an external JavaScript file that is stored externally and not embedded?
How to access an external JavaScript file that is stored externally and not embedded? This can be achieved by using the following tag between head tags or between body tags. &lt;script src="MyScripts.js">&lt;/sc ript>where MyScripts.js is the external JavaScript file to be accessed. 2008-08-26, 5238👍, 0💬

What Are HR Tags/Elements
What Are HR Tags/Elements? - XHTML 1.0 Tutorials - Body Tag and Block Level Tags A "hr" element is a block level element that can be used directly as a sub-element in the body element. You can use "hr" elements to specify horizontal rulers. Here are basic rules about "hr" elements: "hr" elements can... 2007-05-12, 5238👍, 0💬

What Are the Differences between CHAR and VARCHAR
What Are the Differences between CHAR and VARCHAR? - MySQL FAQs - Introduction to SQL Basics CHAR and VARCHAR are both ASCII character data types by default. But they have the following major differences: CHAR stores values in fixed lengths. Values are padded with space characters to match the speci... 2007-05-11, 5237👍, 0💬

Is JSP Technology Extensible
Is JSP technology extensible? YES. JSP technology is extensible through the development of custom actions, or tags, which are encapsulated in tag libraries. 2007-04-03, 5237👍, 0💬

What is a monitor object
What is a monitor object? Monitor objects are used to ensure that a block of code runs without being interrupted by code running on other threads. In other words, code in other threads cannot run until code in the synchronized code block has finished. SyncLock and End SyncLock statements are provide... 2007-10-22, 5235👍, 0💬

How To Check Server Status with "mysqladmin"
How To Check Server Status with "mysqladmin"? - MySQL FAQs - Administrator Tools for Managing MySQL Server If you want to check the server status by with "mysqladmin", you can following this tutorial example: >cd \mysql\bin >mysqladmin -u root status Uptime: 223 Threads: 1 Questions: 1 Slow queries:... 2007-05-11, 5235👍, 0💬

How To Get Execution Statistics Reports on Query Statements
How To Get Execution Statistics Reports on Query Statements? - Oracle DBA FAQ - Introduction to Command-Line SQL*Plus Client Tool If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statement... 2007-04-30, 5234👍, 0💬

How To Use Values from Other Tables in UPDATE Statements
How To Use Values from Other Tables in UPDATE Statements? - Oracle DBA FAQ - Understanding SQL DML Statements If you want to update values in one with values from another table, you can use a subquery in the SET clause. The subquery should return only one row for each row in the update table that ma... 2007-04-21, 5234👍, 0💬

What are queues and stacks
What are queues and stacks ? Queue is for first-in, first-out (FIFO) structures. Stack is for last-in, first-out (LIFO) structures. 2007-10-23, 5233👍, 0💬

How To Generate a Feed Entry title Element
How To Generate a Feed Entry title Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;title&gt; element is a required sub-element of the &lt;entry&gt; element. The title element should contain a short but human readable title of the feed entry. You should follow the ... 2007-05-12, 5233👍, 0💬

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

What is SQL Cache Dependency in ASP.NET 2.0
What is SQL Cache Dependency in ASP.NET 2.0? SQL cache dependencies is a new feature in ASP.NET 2.0 which can automatically invalidate a cached data object (such as a Dataset) when the related data is modified in the database. So for instance if you have a dataset which is tied up to a database tabl... 2007-10-23, 5231👍, 0💬

How Arrays Are Passed Through Arguments
How Arrays Are Passed Through Arguments? - PHP Script Tips - Creating Your Own Functions Like a normal variable, an array is passed through an argument by value, not by reference. That means when an array is passed as an argument, a copy of the array will be passed into the function. Modifying that ... 2007-04-24, 5231👍, 0💬

What are major events in GLOBAL.ASAX file
What are major events in GLOBAL.ASAX file ? Application_PostRequestHandler Execute:Fired when the ASP.NET page framework has finished executing an event handler. Applcation_PreSendRequestHeade rs:Fired before the ASP.NET page framework sends HTTP headers to a requesting client (browser). Application... 2007-10-24, 5227👍, 0💬

How To Generate a Feed author Element
How To Generate a Feed author Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;author&gt; element is not a required sub-element of the &lt;feed&gt; element. However, it is required to have a feed author element, if one of the feed entries does not have an author el... 2007-05-12, 5227👍, 0💬

<< < … 53 54 55 56 57 58 59 60 61 62 63 … > >>   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