| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| How do you load large data to the SQL server database? | | 2 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| syntax for deleting the database in T SQL | | 4 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
| TCS | 5 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| can foreign key take role of primary key?
| TCS | 4 |
| can primery key be a non clustered index? | | 8 |
| how to implement locking in sql server | Satyam | 1 |
| From where can you change the default port? | | 3 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
