| Other SQL Server Interview Questions |
|| Asked @
|What is the role that is required for killing a process
What is the role that is required for creating a linked
|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.
|What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
|write sql program to get the detail of student in a class?
|write query for fourth maximum salary from employee table
|How can you see what type of locks used?
|What is Dedicated Administrator Connection in sql server
|write down the sql query?
Table Name : emp1
Table Name : emp2
Solution : emp1 names are updated in emp2, write a query?
|How to link up the text file to a Database table?
|What is index?
|Following are some of the question related to below
select e1.salary from employee3 e1
from employee3 e2 where e2.salary>=e1.salary
1) What the query returns?
2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?
|what is a cursor and what is its use?
|For more SQL Server Interview Questions Click Here |