What is inner join? Explain with an example?
No Answer is Posted For this Question
Be the First to Post Answer
What is a scheduled job or what is a scheduled task?
What is database white box testing?
When you first load SQL SERVER you will startup with what all databases?
What is the order by used for?
Which language is supported by sql server?
What is surrogate key? : sql server analysis services, ssas
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
How to update multiple rows with one update statement in ms sql server?
New concepts of sql server 2005 use in your project.
How to list all tables having unique constraints in any of the columns in a database.
Can two tables have the same primary key?
What happens to a trigger with multiple affected rows?