| Other SQL Server Interview Questions |
|| Asked @
|Delete duplicate rows from a table without primary key by
using a single query
Output should be
|A left outer join B
B right outer join A gives the same result then what is
the use of two?
|what is DTS what are tasks available
|About Indexed Views? with example?
|What is the difference Between Sql-server 2000 & 2005
|what is the output for this query
select * from employee where 1=1;
|A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query?
|Define Check points and End Points?
|What is the system function to get the current user's user
|In the primary key have a multiple field or not?
|explain different types of jions with examples briefly?
|What are the advantages of using sql server over ms access
or why should one use sql instead of ms access
|For more SQL Server Interview Questions Click Here |