| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to implement locking in sql server | Satyam | 1 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| Explain the new features of SQL server 2000? | | 1 |
| write the query for taking database restore in sql? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 3 |
| what is hash table | Teledata | 2 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| What is the datatype returned by count(*) | Asian-CERC | 16 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 2 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 3 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| what is the query and condition to delete datas in sql
server. | | 1 |
| How can you get @@error and @@rowcount at the same time? | | 4 |
| how to delete duplicate rows from table in sql server | hcl | 1 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| What is normalization in Database ? | | 3 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 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 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
