Explain about protocol layer present in SQL server?
What are the different types of backups avaialabe in sql server 2005?
What is bit data type?
What is ACID Property of Transaction?
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?
How can I track the changes or identify the latest insert-update-delete from a table?
What is the difference between indexing and hashing?
write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car
What is normalization and its types?
What does the INSTEAD OF trigger do?
Can we use where and having clause together?
How can you append an identity column to a temporary table?
How to write an inner join with the where clause in ms sql server?