| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is Deadlock? | Satyam | 3 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| plz send every query in sql server2000 | Infosys | 1 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500
Output should be
A 200
B 300
C 400
D 500
| | 2 |
| i want to create procedure for create table in sql server
2005
for example
create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?
| Aptech | 4 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 2 |
| 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 to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| What are the different types of joins and what does each do? | | 2 |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| what is the difference between group and having
give an example with query and sample output | | 2 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
