What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

How to get a list of all tables with "sys.tables" view in ms sql server?

0 Answers  

---

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,

---

What functions can a view be used to performed?

0 Answers  

---

How to return the second 5 rows in ms sql server?

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

What is a coalesce function?

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

Is sql server 2016 free?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---