What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ?
Answer Posted / anand
select top 10(fieds_name) from <table_name> order by
(fields)name) desc.
Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
How self join is different from outer join?
What is the name of reporting services config file and what’s it’s used for?
What is the full form of dql?
How to attach adventureworkslt physical files to the server?
Explain what are magic tables in sql server?
Difference between DELETE and TRUNCATE?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is difference between view and materialized view?
What are views in ms sql server?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What command is used to delete a table from the database in the sql server and how?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Ways to improve the performance of a SQL Azure Database?