I have an insert statement which will copy data from tables in one database to another database on the same server.
I need to generate the queries dynamically as I don't know the table names from the other database. I know that the column TIMESTAMP can not be included in the INSERT list as it will throw this error:
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.
I need to know like this how many data types are there in SQL Server 2008. I can exclude these data types while inserting the data.
If anybody have any handy information it will be very helpful.