| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| Following are some of the question related to below
mentioned query?
select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
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?
| | 3 |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| How do you simulate a deadlock for testing purposes | | 1 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| About DTS usage ? | Cognizent | 2 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| How will u get 5 years back record? | | 4 |
| Hello all,
I have data like :-
year amt
2004 10
2005 20
2006 30
Now i want output as:-
2004 2005 2006
10 30 60
but i have to use here group by on year.So, i need a single
query within that i can find.
| | 2 |
| how to know description of a table in sqlserver 2000
| | 7 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| write the query for taking database restore in sql? | | 2 |
| 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 |
| how do we find every fifth record in a table | | 11 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
