What is optimization and its types?

0 Answers  

---

What happens to a statement batch if there is a compilation error?

0 Answers  

---

Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,

---

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 full outer join in sql server joins?

0 Answers  

---

How do I start sql server 2017?

0 Answers  

---

Can two tables share the same primary key?

0 Answers  

---

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

---

What is a primary index?

0 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  

---

What is model database? : SQL Server Architecture

0 Answers  

---