| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| Explain the architecture of SQL Server? | | 2 |
| What is a join and their types? | Challenger-Financial | 2 |
| 1.can we set the more than 1 primary keys for a table?
2.please give me the difference between Cluster Index and
non-Clustered Index
3.can we use query like this "Select * from Table1,Table2;" | | 6 |
| table:employee
EID ENAME MID(manager ids)
101 rama null
102 sita 101
103 siva 101
104 ganesh 103
. . .
. . .
for 103 ID the manager ID is 101(RAMA) and for 104 manager
is SIVA
if i give employee id (EID) you have to tell the manager for
that EID write query?
eample:if i give 102 .The query output should be manager for
102 ID that it should print RAMA as output
| | 5 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 15 |
| how to dispaly a particular row details from a given table | | 1 |
| which database is best to use in oracle and sql server?
explain reasons? | TCS | 5 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| 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 |
| Hi Friends,
I have a table in which there are thousands of records and
in city field there is NULL value for all records now i want
to change that null value with distinct values in each
record say delhi, bihar, agra, jaipur etc, what will be the
query for that?????
its not possible to update thousands of records one by one.
is there any alternative ...?
Plz help ... its urgent
Thanx in advance | | 1 |
| What is an Index? | Yardi-Software | 3 |
| How do you simulate a deadlock for testing purposes | | 1 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| what is the diffrence between Snap Shot and Transaction
Replication | CSC | 1 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| What is BCP? When do we use it? | | 1 |
| plz send every query in sql server2000 | Infosys | 1 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
