Answer Posted / monty

i have other solution if you have table employee with
duplicate rows. You can create other table that doesn't
have duplicate rows


select distinct * into newtable from employee

What is SQL Azure Fabric?

110

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1160

---

What is left outer join in sql server joins?

1041

---

How to retrieve error messages using mssql_get_last_message()?

1054

---

What are indexes in ms sql server?

1057

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2021

---

How to see the event list of an existing trigger using sys.trigger_events?

1073

---

what happens on checkpoint? : Sql server database administration

1102

---

Explain the creation and execution of a user-defined function in the sql server?

1051

---

What language is sql server written in?

1033

---

What are the disadvantages of merge replication?

1424

---

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

1002

---

do you know how to configure db2 side of the application? : Sql server database administration

1041

---

Explain differentiate between a having clause and a where clause?

913

---

what is hash nonclustered index

969

---