Interested to Buy Any Domain ? << Click Here >> for more details...
how to count datewise data in sqlserver
- 4 Answers
- 15229 Views
- CarrizalSoft Technologies, IndusInd Bank, I also Faced
- E-Mail Answers
Answer Posted / vidit tyagi
select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Can binary strings be used in arithmetical operations?
Explain the commands in sql server?
whats the maximum size of view state??
Does sql server 2000 full-text search support clustering?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are data files?
Describe in brief system database.
What are the recovery models for a database?
What are out-of-range errors with date and time literals?
Explain the truncate command? : SQL Server Architecture
If the job running very slow what is the action you do
What is difference between temp table and cte?
How you can move data or databases between servers and databases in sql server?
What is a covering index?
