Insert Into DevTrackerMy.dbo.MembershipUser(Id,
UserName,
LoweredName,
Description,
Password,
PasswordFormat,
PasswordSalt,
Email,
LoweredEmail,
PasswordQuestion,
PasswordAnswer,
DisplayName,
IsApproved,
IsLockedOut,
CreationDate,
LastActivityDate,
LastLoginDate,
LastLockedOutDate,
LastPasswordChangeDate,
FailedPwdAttemptCnt,
FailedPwdAttemptWndStart,
FailedPwdAnsAttemptCnt,
FailedPwdAnsAttemptWndStart,
IsDismission,
IsNative)select us_id,
us_login_name,
'',
'',
'J20oEpsshlpU2K0dLrIt6wKk0Uo=',
1,
'4BDB52D578574CF316DE3CB1FC7F3CEB8AF5E6324E088EF59D02B870E8C67B176CB3EFA7CEFBD4DDFC64C90653FDDAD709AF8A1DA20F6D598FFA07B58EE765F4',
us_email,
'',
'123456',
'ZK74MBIzpmb30SWtI2fMMlia+g4=',
us_username,
'True',
'False',
GETDATE( ),
GETDATE( ),
GETDATE( ),
GETDATE( ),
GETDATE( ),
0,
GETDATE( ),
0,
GETDATE( ),
'False',
'True'
from
GC_DevUser.dbo.gc_users
Msg 2627, Level 14, State 1, Line 1
Violation of UNIQUE KEY constraint 'MembershipUser_UC1'. Cannot insert duplicate key in object 'dbo.MembershipUser'.
The statement has been terminated.
UserName,
LoweredName,
Description,
Password,
PasswordFormat,
PasswordSalt,
Email,
LoweredEmail,
PasswordQuestion,
PasswordAnswer,
DisplayName,
IsApproved,
IsLockedOut,
CreationDate,
LastActivityDate,
LastLoginDate,
LastLockedOutDate,
LastPasswordChangeDate,
FailedPwdAttemptCnt,
FailedPwdAttemptWndStart,
FailedPwdAnsAttemptCnt,
FailedPwdAnsAttemptWndStart,
IsDismission,
IsNative)select us_id,
us_login_name,
'',
'',
'J20oEpsshlpU2K0dLrIt6wKk0Uo=',
1,
'4BDB52D578574CF316DE3CB1FC7F3CEB8AF5E6324E088EF59D02B870E8C67B176CB3EFA7CEFBD4DDFC64C90653FDDAD709AF8A1DA20F6D598FFA07B58EE765F4',
us_email,
'',
'123456',
'ZK74MBIzpmb30SWtI2fMMlia+g4=',
us_username,
'True',
'False',
GETDATE( ),
GETDATE( ),
GETDATE( ),
GETDATE( ),
GETDATE( ),
0,
GETDATE( ),
0,
GETDATE( ),
'False',
'True'
from
GC_DevUser.dbo.gc_users
Msg 2627, Level 14, State 1, Line 1
Violation of UNIQUE KEY constraint 'MembershipUser_UC1'. Cannot insert duplicate key in object 'dbo.MembershipUser'.
The statement has been terminated.
'MembershipUser_UC1'这个约束