Is it possible to update the views? If yes, how, if not, why?

0 Answers  

---

what is an index? : Sql server database administration

0 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

What is the difference between count and distinct count?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

What are filegroups in sql server?

0 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---

What is #table in sql server?

0 Answers  

---

What is unpivot?

0 Answers  

---

How self join is different from outer join?

0 Answers   Blue Star,

---

What is a view and what are its advantages?

0 Answers  

---