| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me. | 247Customer | 1 |
| 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 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| Differnce between sel server 2000 and 2005 | | 3 |
| 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 Transaction? | | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| What is blocking and how would you troubleshoot it? | | 1 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| 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 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
