Answer / mythili

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

Answer / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

Answer / ambi

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varchar(50),BillDate,101)

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varcharBillDate,101)

Answer / vidit tyagi

select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)

What is difference between foreign key and unique key?

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---

What is the advantage of sql server?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

Can a trigger be created on a view?

0 Answers  

---

Where are full-text indexes stored?

0 Answers  

---

What is sql server locking?

0 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

What is xdr?

0 Answers  

---

What are the steps to process a single select statement?

0 Answers  

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---