Advertisement
compu_85

RIMS Reader

Jan 6th, 2017
373
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.22 KB | None | 0 0
  1. EXEC sp_executesql N'INSERT INTO ras_Enroll ([DIN], [BackupNumber], [Privilege], [Password], [Fingerprint],[Enable], [AccessTimeZone], [ValidDate], [InvalidDate], [UnlockGroup]) VALUES (@DIN, @BackupNumber, @Privilege, @Password, @Fingerprint, @Enable, @AccessTimeZone, @ValidDate, @InvalidDate, @UnlockGroup)',N'@DIN int,@BackupNumber int,@Privilege int,@Password nvarchar(4),@Fingerprint nvarchar(4000),@Enable bit,@AccessTimeZone int,@ValidDate nvarchar(19),@InvalidDate nvarchar(19),@UnlockGroup int',@DIN=9995,@BackupNumber=10,@Privilege=0,@Password=N'9995',@Fingerprint=N'',@Enable=1,@AccessTimeZone=0,@ValidDate=N'2000-01-01 00:00:00',@InvalidDate=N'2099-12-31 00:00:00',@UnlockGroup=0
  2.  
  3. EXEC ras_UserInsert @UID=4,@DIN=9995,@PIN=N'9995',@UserName=N'Test Audit',@Sex=N'',@Password=N'',@PasswordQuestion=N'',@PasswordAnswer=N'',@IsApproved=1,@IsLockedOut=0,@CreateDate=N'2017-01-06 10:06:35',@LastLoginDate=N'2010-08-03 08:08:08',@DeptId=N'AA',@AttId=N'E001',@RuleId=N'R001',@WeekendId=N'W000',@LastUpdatedUID=0,@LastUpdatedDate=N'2017-01-06 10:06:35',@Comment=N'',@IsNew=1
  4.  
  5. EXEC ras_UserExInsert @UID=4,@Email=N'',@Birthday=NULL,@Title=N'',@RegisterDate=N'2017-01-06 10:06:13',@IDNumber=N'',@HomeAddress=N'',@PhoneNumber=N'',@IsNew=1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement