 Related Questions 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 : 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. ... 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 (4) | 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 (13) | Asked by : Ashok Latest Answer : To take backup of the Access database, follow the steps:Alt+F --> Manage --> Backup Database -->Specify the path for the backup ... Read Answers (4) | Asked by : pramod Tags : Backup Which is the best option used to move database from one server to another serve on same network?a) Import - Exportb)Backup-Restorec)Detach-AttachWhy?
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
0 
1