role of sql sever 2005 in database rather than any other
database
why SQL server is more used to store database rather than Access
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is after dml trigger?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
What is clustered index
What is the use of Port no?
What are the different authentication modes in sql server? How can it be changed?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
how would you improve etl (extract, transform, load) throughput?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
How do you find the number of rows in a table?
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?