Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-10 : 08:15:45
|
| mahesh sawant writes "Hi, This is Mahesh. I would like to know the per day transactions happens on my database.Pls provide the way to find the sameRegards,Mahesh" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-10 : 08:31:23
|
| If your table has datetime column then write a query to get the transactions that happened on a daySelect columns from yourTable where Datediff(day,datecol,getdate())=0MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Transaction Count