| Other SQL Server Interview Questions |
|| Asked @
|How many types of Outer Joins?What are they?
|Diffrent types of function
|write query for fourth maximum salary from employee table
|sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format??
|What is Fragmentation and Defragmentation? For 32GB
Table,How can we do the fragmentation?
|What is difference between restoration and recovery in
|A left outer join B
B right outer join A gives the same result then what is
the use of two?
|Is SET a SQL Keyword?
|logshipping is Any difference 2000 and 2005?
|How can you see what type of locks used?
|What is the diff between Static Queries and Dynamic queries
give me some examples
|if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 duplicate and 1 original as it is,how?
|For more SQL Server Interview Questions Click Here |