Answer / ramesh

The Concept of joining a table with it self in called "self
join"

Answer / shekar

the concept of joining a table with it self in called "self
join"

Answer / rrrrrrrrrr

The Concept of joining a table with it self in called "self
join"

Answer / gagan

Self join correlated rows of a table with other rows in the
same table.

Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10

Do you know sql server 2008 backup compression?

0 Answers  

---

How to use "begin ... End" statement structures in ms sql server?

0 Answers  

---

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

What the different components of Replication and what is their use?

0 Answers  

---

Explain trigger classes i.e. Instead of and after trigger?

0 Answers  

---

Do you know what are the properties of the relational tables?

0 Answers  

---

How to end a stored procedure properly in ms sql server?

0 Answers  

---

Can primary key be null?

0 Answers  

---

Can you tell me about the concept of ER diagrams?

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,

---