How to find the latest updated value in a table without
sending any parameters to that query
- 2 Answers
- 4858 Views
- I also Faced
- E-Mail Answers
Answer Posted / honey
by using scope_identity()
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
Can you name a few encryption mechanisms in sql server?
How to rebuild indexes with alter index ... Rebuild?
What are the purposes and advantages stored procedure?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain about temporary stored procedure?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to use subqueries in the from clause in ms sql server?
What is temporal table?
What is the default order of an order by clause?
Why functions are used in sql server?
Do you know what is blocking?
How to receive returning result from a query?
How to delete duplicate records based on single column from a table?
How to disable triggers using "disable trigger"?
