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 program is used to store the data source file?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How exceptions can be handled in sql server programming?
Is it possible to have clustered index on separate drive from original table location?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to edit table in sql server 2017?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Explain about Normalization?
What are date and time data types in ms sql server?
What does the on update no action do?
What are the operating modes in which database mirroring runs?
What are synonyms?
Do you know the cursor types?
What is store procedure? When do you use?
Can sql servers link to other servers like oracle?