How to write stored procedure to update the data in 10 tables

4 Answers  

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

What is table level trigger?

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,

---

Explain user defined functions?

0 Answers  

---

Is foreign key a primary key?

0 Answers  

---

What is the exact numeric data type in sql?

0 Answers  

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

---

Explain timestamp datatype?

0 Answers  

---