Answer / swapna

DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC
CHECKALLOC, DBCC SHOWCONTIG, DBCC SHRINKDATABASE, DBCC
SHRINKFILE etc.

How do I find the query plan in sql server?

0 Answers  

---

Explain the third normal form(3nf)?

0 Answers  

---

Define ACID properties in a Database?

0 Answers   iNautix,

---

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

---

Why and when do stored procedure recompile?

0 Answers  

---

---

Can primary key be null?

0 Answers  

---

What are different types of join?

0 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

How to loop through returning rows?

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 authentication modes does sql server support? : Sql server database administration

0 Answers  

---

How to download and install the scaled-down database adventureworkslt?

0 Answers  

---