|
| 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 : 1. Optimise DB performance ... 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 Latest Answer : Select Columnname from Tablename Groupby Columnname Having Count*>1 ... Read Answers (10) | Asked by : Srinu 1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name Read Answers (1) | Asked by : lavanya 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 Latest Answer : I Think the question is not well formed.. Please Elaborate ... Read Answers (1) | Asked by : Chetan Shewale What is the difference between Inner join and full outer join in terms of the Number of rows returned? Latest Answer : CREATE PROCEDURE [usp_delete_Pataint_master] (@PataintID [int], @BranchID [int] )AS BEGIN SET NOCOUNT ON BEGIN TRAN DELETE [dbo].[Pataint_master] WHERE ([BranchID] = @BranchID ... Read Answers (3) | Asked by : soumya Latest Answer : #temp table: the table define with single '#' called local temp table, it can be used only a single project of a databse for exemple if we are making a new query in query builder and declare a #temp table then this temp table only can be used for that ... Read Answers (5) | Asked by : sunileswar behera Latest Answer : Therefore sp_columns dataloader.rescomps will display column names and their descriptions. ... Read Answers (8) | Asked by : Priya
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
