Difference between ASP Session and ASP.NET Session ?
asp.net session supports cookie less session & it can span across multiple servers. Read more »
Archive for July, 2008
What happens when you say OPEN CURSOR ?
If there is an ORDER BY clause, rows are fetched, sorted and made available for the FETCH statement. Other wise simply the cursor is placed on the first row. Read more »
What is a join ?
A join is a relational operation that allows retrieval of data from two or more tables based on matching columns values. Read more »
What is an index key ?
It is a column or set of columns in a table used to determine the order of index entries. Read more »
When do you use a LIKE statement ?
To do partial search e.g. to search employee by name, you need not specify the complete name; using LIKE, you can search for partial string matches. Read more »
What is ‘LIKE’ used for in WHERE clause? What are the wildcard characters ?
LIKE is used for partial string matches. ‘%’ ( for a string of any character ) and ‘_’ (for any single character ) are the two wild card... Read more »
In the WHERE clause what is BETWEEN and IN ?
BETWEEN supplies a range of values while IN supplies a list of values. Read more »
What is the restriction on using UNION in embedded SQL ?
It has to be in a CURSOR. Read more »
How do you retrieve the first 5 characters of FIRSTNAME column of EMP table ?
SELECT SUBSTR(FIRSTNAME,1,5) FROM EMP; Read more »
My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. Why ?
Because SALARY is not declared to have Null’s and the employees for whom the salary is not known are also counted. Read more »