Using the customer, and order table in northwind database, please write a query to produce xml?
Explain what are magic tables in sql server?
What is the Disadvantage of indexed sequential file.
What is unique key constraint?
How use inner join in sql server?
Please tell me some knowledge about Clustering and how to add clustering?
List some major differences between triggers and stored procedures?
How the authentication mode can be changed?
Explain about integration services of Microsoft SQL server?
Define compound operators?
How do you read transaction logs
Explain unique key in sql server?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.