| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 6 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| What's the purpose of Stored Procedure? | Wipro | 4 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| HOW TO RENAME A COLUMN NAME | | 2 |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 3 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| what is replication?
where do u use Go Keyword?
| Satyam | 1 |
| How can you see what type of locks used? | | 1 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| what is hash table | Teledata | 2 |
| 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 |
| 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 use of CASCADE CONSTRAINTS? | | 2 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |