What is @@rowcount in sql?

0 Answers  

---

To find second largest salary in Employee table

17 Answers   CSS,

---

What are the diifferences between the ms sql server vs mysql?

0 Answers  

---

Can an automatic recovery be initiated by a user?

0 Answers  

---

What the class forname () does?

0 Answers  

---

---

When is the use of update_statistics command?

0 Answers  

---

how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

---

What is the purpose of a table?

0 Answers  

---

Define the term DML, DDL and DTL?

1 Answers  

---

What is index?

1 Answers   Cap Gemini,

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---