Answer / guest

No. We cannot use Truncate command on a table with Foreign
Key because of referential integrity.

Answer / samji

Cacase can be used to delete a table which is referenced
by FOREIGN KEY

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 difference between after and before?

0 Answers  

---

what is unique and xaml nonclustered index

0 Answers  

---

What are the main sources of data?

0 Answers  

---

How to perform backup for certificates in sql server? : sql server security

0 Answers  

---

What is Deadlock?

4 Answers   Satyam,

---

Explain the properties of sub-query in sql server?

0 Answers  

---

What is the purpose of sql profiler in sql server? : sql server database administration

0 Answers  

---

What is the purpose of the master database?

0 Answers  

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

---

How to select all columns of all rows from a table with a select statement in ms sql server?

0 Answers  

---