I am working on a project where I can transfer data from one database to another (with some minor changes) is required. When I hit my first timestamp column then everything was going well ...
It seems that SQL Server does not want to use explicit values for this type of column and instead, its Wants to generate its own.
If there is a way to use T-SQL, can I get this data from one table to another?
Note: The timestamp of the name is disliked, the new (more accurate) name line description is.
Two answers:
No: SQL Server column type lineWarson is always generated and set by the database server.
Yes: If you use a different datatype in the target table, the value read from the queue column can be stored in a varbinary column. You can create a varbinary column in the new table to keep the value from the old table. Of course, going forward, this verb column does not automatically update like a row column.
Comments
Post a Comment