Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-25 : 12:04:46
|
Korranat writes "Hi All
I transfer data from Database A to Database B but, I have some problem in identify field so, I try to use command "IDENTIRY_INSERT" before insert data.
SET IDENTITY_INSERT B ON
SQL Command for insert .......
SET IDENTITY_INSERT B OFF
Sometime, This process it work but somethime it not work.
For Example : ( Database A have 200 records.)
After run this process, sometime I can get the complete results but sometime I can get 1 record only.
So, If everyone have the suggestion please tell me.
Thank & Regards." |
|
|
|
|
|
Identity insert