| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 4 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 1 |
| Anyone please explain me the concept of Serialization? | | 2 |
| How to Run a Query on a Remote SQL Server? | | 1 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| What is the difference between constraints and triggers? | Wipro | 5 |
| What are the type of Indexes? which one is best, why? | | 5 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| What is the difference between having and where clause? | | 3 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| What is lock escalation? | | 1 |
| 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 | 2 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| How do you load large data to the SQL server database? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map