Answer / Amit Kumar Gupta

The main differences between a table and a view in SQL Server are:
1. Tables store data, while views only contain virtual tables derived from one or more existing tables.
2. Tables can be directly manipulated (INSERT, UPDATE, DELETE), whereas views cannot.
3. Tables have a physical representation on disk, while views do not.

What is transactional replication?

1 Answers  

---

how to take backup bcp out for a column in table in sql server?

1 Answers  

---

How many null values we can have in a unique key field in sql server?

1 Answers  

---

How many .ndf files can we create in Sql server 2005?

2 Answers   Wipro,

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

What happens to a trigger with multiple affected rows?

1 Answers  

---

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1 Answers  

---

What is the default value of an integer data type in sql server 2005?

1 Answers  

---

Explain comment on transactions?

1 Answers  

---

How To delete duplicate record from a particular table?

12 Answers   eXensys, Foxfire,

---

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

1 Answers  

---