| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is difference between Triggers and store procedure? | | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| what is diffence between replicaion and logshipping? | | 1 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| What is the difference between Drop and Truncate | | 10 |
| what are the new features of sql server 2005? | HP | 5 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 4 |
| How many types of cursors are there in SQL Server? | 247Customer | 3 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| how to count datewise data in sqlserver | IndusInd-Bank | 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 are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| what purpose does OPENXML clause have in sql server stored
procedure? | | 1 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| |
| For more SQL Server Interview Questions Click Here |