帮忙找个错误 晕了都
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.