|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions Latest Answer : Hints are options or strategies specified for enforcement by the SQL Server 2005 query processor on SELECT, INSERT, UPDATE, or DELETE statements. The hints override any execution plan the query optimizer might select for a query. ... 1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT Read Answers (3) | Asked by : samir khan Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no. Read Answers (11) | Asked by : laxman Write sql query for retrieving employee names from employee table who are having salary greater than Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause? Read Answers (12) | Asked by : Ashok Latest Answer : use IsNULL(,value) .If query return null ,it will replace by value. ... Latest Answer : select * from sysobjects where xtype='U' ... Read Answers (4) | Asked by : Sree hari Write an SQL query if you want to select the data from one block which intern reflects in another block?
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
