What are the dis_advantages of stored procedures, triggers, indexes?

0 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

What are the advantages of having an index on the sql server?

0 Answers  

---

What is the use of toad or sqldbx.?

0 Answers   MCN Solutions,

---

What is the new security features added in sql server 2016? : sql server security

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,

---

What is subquery explain with example?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

What are the database objects? : SQL Server Architecture

0 Answers  

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

what is a correlated sub-query? : Sql server database administration

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---