What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

---

What is the need for group functions in sql?

0 Answers  

---

What happens if null values are involved in boolean operations?

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 built-in/administrator?

0 Answers  

---

---

Define right outer join in sql server joins?

0 Answers  

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

0 Answers  

---

What is stretch database in sql server?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

How to delete a database in ms sql server?

0 Answers  

---

How to list all objects in a given schema?

0 Answers  

---

How do you test your database? : sql server database administration

0 Answers  

---