| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 1 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| Difference between Function and Procedure-in general? | | 2 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 2 |
| how to delete duplicate rows from table | CSC | 2 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 3 |
| I have a website that allows customers to browse and place
orders for certain products.
I have 2 tables; Customers and Orders. The Customers table
holds the customer records and the Orders table
holds the orders placed by the customer. Both tables are
tied based on the field Cust_ID.
Example of the data is shown below:
Cust_ID Cust_Name Cust_ID Product Amount Order_Date
1001 John Tan 1001 P-5211 $120.00 2/13/2006
1002 Michael Wong 1001 K-1428 $88.90 1/11/2006
1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006
1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006
Write a single SQL statement that extracts all purchase
records with the following criteria:
1. Customer names starting with “M” only.
2. Orders placed within the current month only.
3. Amount does not exceed $100.00
The list must be sorted by order date with the latest order
showing on top. | Techno-Solutions | 3 |
| What's the purpose of Stored Procedure? | Wipro | 3 |
| How To delete duplicate record from a particular table? | eXensys | 8 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| When do you use SQL Profiler? | | 2 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 6 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| How do you know which index a table is using? | | 4 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 2 |
| How many index keys possible for a table | | 6 |
| is there more the two primary key in a single table? | Systematix | 19 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
