| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which stored procedure will you be running to add a linked
server? | | 1 |
| what is physical sort data and logical sort data in index? | | 2 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| How do you persist objects, permissions in tempdb | | 1 |
| Differnce between sel server 2000 and 2005 | | 3 |
| select top 5 * from emp order by newid()
my question is , how this query get executed? | | 4 |
| 1.what is the purpose of using alias name in sql server?
with certain example?
2.what is cursor?will u plz explain me in detail with
certain example? | | 3 |
| How many index keys possible for a table | | 6 |
| How do you fine the performance tunning? | Accenture | 2 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 11 |
| 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 |
| what is web server?
| Satyam | 3 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| Which is better in performance - CONSTRAINT or TRIGGER over
a column which restricts say an input of particular value
in a column of a table? | Accenture | 3 |
| Can you create UNIQUE and PRIMARY KEY constraints on
computed columns in SQL Server 2000? | Infosys | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
