Answer Posted / soorai ganesh

Hey dude, If u use SQLSERVER 2005 This will help u.


;WITH tmpEmp AS
(
SELECT ROW_NUMBER() OVER(PARTITION BY EmpID ORDER BY EmpID)
AS RowNumber, * FROM EMP
)

DELETE FROM tmpEmp WHERE RowNumber> 1

Which are ddl commands?

980

---

Explain microsoft sql server functions?

1036

---

How to use wildcard characters in like operations in ms sql server?

1065

---

How to find related tables in sql server?

874

---

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

924

---

How to create stored procedures with parameters in ms sql server?

993

---

Explain different types of collation sensitivity?

926

---

Explain “row_number()” in sql server with an example?

950

---

What is the advantage of sql server?

989

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2165

---

List the advantages of using stored procedures?

999

---

What different steps will a sql server developer take to secure sql server?

935

---

What is the report builder?

131

---

Explain primary key and foreign key constraints?

966

---

How do I open a .db file?

976

---