<< < 47 48 49 50 51 52 53 54 55 56 57 > >>   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, 5526👍, 0💬

How To Float an Image to the Right Side
How To Float an Image to the Right Side? - XHTML 1.0 Tutorials - Understanding Inline Images and Image Maps If you want to float an image to the right side of the paragraph instead of inline within a text line, you have to use the CSS property "float" to do this. The "float" property takes two value...
2007-05-12, 5523👍, 0💬

What Is PCDATA
What Is PCDATA? - XHTML Tutorials - Introduction To Element Content Syntax PCDATA stands for Parsed Character DATA. Here are some basic rules about PCDATA: PCDATA is a string of characters and XHTML entities. XHTML entities are escape sequences used to refer to special characters that are not so eas...
2007-05-12, 5523👍, 0💬

What Are the General Rules on Data Consistency
What Are the General Rules on Data Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management All SQL statements always work with a snapshot of the database to provide data consistency. For READ WRITE transactions, the snapshot is taken when each statement starts. For READ ONLY transac...
2007-04-17, 5523👍, 0💬

What is one way operation
What is one way operation? IsOneWay equal to true ensures that the client does not have to wait for the response. So methods marked by IsOneWay to true should always return void. In this the caller does not get anything in return so it is called as one-way communication. In order to understand one w...
2007-11-04, 5522👍, 0💬

What are the various roles in Six Sigma implementation
What are the various roles in Six Sigma implementation? Attaining Six Sigma is team effort and can not be attained individually. Driving Six Sigma itself in an organization is huge project as it involves lot of mentoring and change of attitude of the current workers. So when an organization wants to...
2007-10-30, 5522👍, 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, 5522👍, 0💬

In a pop-up browser window, how do you refer to the main browser window that opened it?
In a pop-up browser window, how do you refer to the main browser window that opened it? Use window.opener to refer to the main window from pop-ups.
2008-06-17, 5521👍, 0💬

How To Test the Session Garbage Collection Process
How To Test the Session Garbage Collection Process? - PHP Script Tips - Understanding and Using Sessions In order to test the session garbage collection process, you need to change the settings to expire session variables in 10 seconds and run the process on every request: session.gc_probability = 1...
2007-04-18, 5521👍, 0💬

What Are Numeric Data Types
What Are Numeric Data Types? - MySQL FAQs - Introduction to SQL Basics MySQL supports the following numeric data types: BIT(n) - An integer with n bits. BOOL same as BOOLEAN - Boolean values stored in 1 bit. TINYINT - A small integer stored in 1 byte. SMALLINT - A small integer stored in 2 bytes. ME...
2007-05-11, 5520👍, 0💬

What Happens If Variable Names Collide with Table/Column Names
What Happens If Variable Names Collide with Table/Column Names? - Oracle DBA FAQ - Working with Database Objects in PL/SQL When a variable name collides with a column name, PL/SQL will use it as the variable if it is used where variable is allowed; It will be used as the column, if it is used where ...
2007-04-28, 5520👍, 0💬

ASP used STA threading model, what is the threading model used for ASP.NET
ASP used STA threading model, what is the threading model used for ASP.NET ? ASP.NET uses MTA threading model.
2007-10-24, 5519👍, 0💬

What Are the System Predefined User Roles
What Are the System Predefined User Roles? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle 10g XE comes with 3 predefined roles: CONNECT - Enables a user to connect to the database. Grant this role to any user or application that needs database access. RESOURCE - Enabl...
2007-05-02, 5518👍, 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, 5517👍, 0💬

What is the difference between “Web.config” and “Machine.Config”
What is the difference between “Web.config” and “Machine.Config” ? “Web.config” files apply settings to each web application, while “Machine.config” file apply settings to all ASP.NET applications.
2007-10-24, 5516👍, 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, 5516👍, 0💬

How do you estimate a project
How do you estimate a project? There are many techniques available for estimating a project: Function points Use Case points WBS etc etc.
2007-10-30, 5514👍, 0💬

How To Generate a Feed id Element
How To Generate a Feed id Element? - RSS FAQs - Atom Feed File Structure and Elements The &lt;id&gt; element is a required sub-element of the &lt;feed&gt; element. The Atom specification requires that you provide a universally unique identifier for each of your feeds. So how to make ...
2007-05-12, 5514👍, 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, 5514👍, 0💬

What is the use of OLAP
What is the use of OLAP ? OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail.
2007-10-25, 5511👍, 0💬

How To Unlock the Sample User Account
How To Unlock the Sample User Account? - Oracle DBA FAQ - Introduction to Oracle Database 10g Express Edition Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click t...
2007-04-24, 5511👍, 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, 5510👍, 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, 5510👍, 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, 5508👍, 0💬

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