Is sql different from sql server?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
What are the new security features added in sql server 2012? : sql server security
what is differece between union and union all
How do I port a number to sql server?
how to delete duplicate rows from table in sql server
12 Answers HCL, UHG,
What are tables in sql server?
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
What happens to a statement batch if there is a compilation error?
Define indexes?
Can we use trigger new in before insert?
Tell me the phases a transaction has to undergo?
what is the difference between count(*) and count(1) ?