|
| 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)function returns a value.... procedure does not returns a value.....2) in function will pass the many input parameters and wiull get only one output parameter with return value....But procedure we can get more than one output parameter.... ... Latest Answer : Right click table in SSMS > Script Table as > CreateYour question of "copy" infers that you want all the constraints. The example that you give doesn't fill the requierments. As you want the structure you would als ... Latest Answer : A transaction is a group of operations combined into a logical unit of work. Developer uses transactions to control and maintain the consistency and integrity of each action in a transaction, despite errors that might occur in the system BEGIN ... Latest Answer : You can use Bulk copy program (BCP) to convert a data from row to text or text to row ... Latest Answer : Normalization is the technique of breaking the complex tables into much understandable smaller one to improve the optimzation of the database structure. The concept of "Fucntional Dependancy" is followed in Second Normal Form (2NF) which means ... Latest Answer : Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com ... What is the use of database index (apart from fast searching of records);What is use of composite key ? Read Answers (2) | Asked by : forces I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code? Tags : Backup 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 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
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
1 
0