| Other SQL Server Interview Questions |
|| Asked @
|What are the advantages of using views. Why do we need
views when we have SPs?
|What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same?
|syntex of insert
|Following are some of the question related to below
select e1.salary from employee3 e1
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?
|what purpose does OPENXML clause have in sql server stored
|how to count datewise data in sqlserver
|How to write stored procedure to update the data in 10
|How to find the date and time of last updated table?
|What is the difference between in and exists.
Ex: select * from emp where empno in(....) and
select * from emp where empno exists(....)
What is the difference between a Join and Union and Union
|WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY
AND PRIMARY KEY.
|here id col have primary key and identity
delete 2nd row then o/p will be
next inssert 2nd row and i want o/p will be
|What is SQL Profiler what is the use of it?
|For more SQL Server Interview Questions Click Here |