adspace


What is history table in sql server?

Answer Posted / Devendra Kumar Yadav

A History Table in SQL Server is a special type of table that stores the historical versions of data for auditing or reporting purposes. It can be created manually, or using features like Change Tracking or Temporal Tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to have clustered index on separate drive from original table location?

1047


Why and when do stored procedure recompile?

1075


Equi join and non equi join is possible with sql server?

1139


Explain “row_number()” in sql server with an example?

1086


What is temporary table in sql server? Why we use temp table?

1027


Where can you add custom error messages to sql server?

1220


What is acid mean in sql server?

1257


do you know how to configure db2 side of the application? : Sql server database administration

1132


What is self contained sub query?

1147


How to provide default values to function parameters?

1272


How to remove duplicate rows from table except one?

1096


What are the properties of the transaction?

1079


What is sql or structured query language?

1232


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1209


How do I find the sql server version?

1114