What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ?
Answer Posted / mona
select top 10 (field list) from (tablename) order by (your
autonumbering/identity column) desc
| Is This Answer Correct ? | 5 Yes | 19 No |
Post New Answer View All Answers
What is dirty read?
What are the differences between local and global temporary tables?
List the various tools available for performance tuning?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
What are the different type of replication in sql server?
How to create new databases with "create database" statements?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
How do you create an execution plan?
A trigger can reference objects outside the current database? State true or false.
what's the information that can be stored inside a bit column? : Sql server database administration
What is a join in sql?
How to create a simple stored procedure in ms sql server?
What is snapshot replication?
What is the sql case statement used for?
How to locate and take substrings with charindex() and substring() functions?