Answer Posted / kapil
There are two virtual table
inserted and deleted
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the different types of sql server replication? : sql server replication
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.
Describe how to use linked server?
How to filter out duplications in the returning rows in ms sql server?
What are the limitations/drawbacks or ssrs 2008 r2?
How can we improve performance by using SQL Server profiler?
Can select statements be used on views in ms sql server?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What are different types of replication in sql server?
Do you know what is blocking?
What is the difference between char, varchar and nvarchar?
what is the difference between openrowset and openquery?
what is sql server? : Sql server database administration
Why do we partition data?
When to use Inner join & when to use subquery?