Why use “pivot” in sql server?

0 Answers  

---

Why do we need different type of parameter?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

---

Find first and last day of current month in sql server

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

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,

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

What is the xml datatype?

0 Answers  

---

Explain go command in sql server?

0 Answers  

---