| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| logshipping is Any difference 2000 and 2005? | | 1 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| what are the new features of sql server 2005? | HP | 6 |
| Explain the storage models of OLAP? | | 1 |
| what is differece between union and union all | | 4 |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| 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 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| 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 | 5 |
| Why Do you want to work in this company? | HCL | 3 |
| hi,
i have a table called names and field name
select * from names
name
a
b
c
d
i want to display like this
name
a,b,c,d
how it is possible
Regards
Baiju | | 3 |
| to explain sql server 2000 architecture & authentication | | 1 |
| What is a transaction and what are ACID properties? | IBM | 4 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| What is indexed views?
plz explain with example? | | 1 |
| What's the maximum size of a row? | | 4 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
