Answer Posted / mythili

select BillDate, count(*) from AdminSalesDetailsItems group by BillDate

What is inner join in sql server joins?

554

---

How do I manually uninstall an instance of sql server 2016?

556

---

How to copy data from one table to another table?

553

---

What are the aggregate and scalar functions?

531

---

What are the types of ssrs?

108

---

---

what stored procedure can you use to display the current processes? : Sql server administration

534

---

Which is faster statement or preparedstatement?

547

---

How to delete all rows with truncate table statement in ms sql server?

500

---

Explain about local stored procedure?

512

---

Tell me in brief how sql server enhances scalability of the database system?

542

---

What is row_number function?

597

---

Find nth lowest salary or get nth lowest salary?

605

---

What do you understand by check constraint in sql server?

490

---

Explain the concept of view and Types of views in SQL server?

630

---

Why and when do stored procedure recompile?

553

---