/*
Select * from dbo.dataFriend
Insert DataFriend ( BoardID, RefID, p_DataID, dataDepth, nonRef, Title, ID, No, NickName, Regdate, ReadNum, avataInfo, Contents,
gubun, memoCnt, JobCode, Age, VisitTime, AreaCode, HobbyCode, GameCode, Sex, Talking, RepCnt, blnNotice )
Values( 129, 0.99999999999999999999, 0, 0, 1, 'バ?ジョンアップに反映されます', 'siri94', 'nm0000000023', 'sirius94', getdate(), 0, '0|0|0|0|1|1|160|1|0|1|0|0|1|0|3286|0|1|0|0|0|0|0|0|0|0|0', 'ネチケットを守りましょう。 花札に?係のない?容は予告なく削除する場合があります ' ,
Null, Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), 0, NULL)
Select ID, NickName from SQLSVR.dbo.User_Info1
*/
Declare @RegID Decimal(28,20), @RRegID Decimal(28,20)
Declare @ii INT
Declare @P_dataID Decimal(28,20)
SET @RegID = 0.99999999999999999999
SET @ii = 1
While @ii < 100
Begin
SET @RegID = @RegID + 1.00000000000000000000
Insert DataFriend ( BoardID, RefID, p_DataID, dataDepth, nonRef, Title, ID, No, NickName, Regdate, ReadNum, avataInfo, Contents,
gubun, memoCnt, JobCode, Age, VisitTime, AreaCode, HobbyCode, GameCode, Sex, Talking, RepCnt, blnNotice )
Values( 129, @RegID, 0, 0, 1, 'バ?ジョンアップに反映されます', 'user01', 'nm0000000023', 'user0001', getdate(), 0, '0|0|0|0|1|1|160|1|0|1|0|0|1|0|3286|0|1|0|0|0|0|0|0|0|0|0', 'ネチケットを守りましょう。 花札に?係のない?容は予告なく削除する場合があります ' ,
Null, Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), 0, NULL)
SET @P_dataID = @@Identity
SET @RRegID = @RegID - 0.01000000000000000000
Insert DataFriend ( BoardID, RefID, p_DataID, dataDepth, nonRef, Title, ID, No, NickName, Regdate, ReadNum, avataInfo, Contents,
gubun, memoCnt, JobCode, Age, VisitTime, AreaCode, HobbyCode, GameCode, Sex, Talking, RepCnt, blnNotice )
Values( 129, @RRegID, @P_dataID, 1, 1, 'バ?ジョンアップに反映されます', 'user01', 'nm0000000023', 'user0001', getdate(), 0, '0|0|0|0|1|1|160|1|0|1|0|0|1|0|3286|0|1|0|0|0|0|0|0|0|0|0', 'ネチケットを守りましょう。 花札に?係のない?容は予告なく削除する場合があります ' ,
Null, Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), 0, NULL)
SET @P_dataID = @@Identity
SET @RRegID = @RRegID - 0.00010000000000000000
Insert DataFriend ( BoardID, RefID, p_DataID, dataDepth, nonRef, Title, ID, No, NickName, Regdate, ReadNum, avataInfo, Contents,
gubun, memoCnt, JobCode, Age, VisitTime, AreaCode, HobbyCode, GameCode, Sex, Talking, RepCnt, blnNotice )
Values( 129, @RRegID, @P_dataID, 2, 1, 'バ?ジョンアップに反映されます', 'siri94', 'nm0000000023', 'sirius94', getdate(), 0, '0|0|0|0|1|1|160|1|0|1|0|0|1|0|3286|0|1|0|0|0|0|0|0|0|0|0', 'ネチケットを守りましょう。 花札に?係のない?容は予告なく削除する場合があります ' ,
Null, Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), 0, NULL)
SET @P_dataID = @@Identity
SET @RRegID = @RRegID - 0.00000100000000000000
Insert DataFriend ( BoardID, RefID, p_DataID, dataDepth, nonRef, Title, ID, No, NickName, Regdate, ReadNum, avataInfo, Contents,
gubun, memoCnt, JobCode, Age, VisitTime, AreaCode, HobbyCode, GameCode, Sex, Talking, RepCnt, blnNotice )
Values( 129, @RRegID, @P_dataID, 3, 1, 'バ?ジョンアップに反映されます', 'user01', 'nm0000000023', 'user0001', getdate(), 0, '0|0|0|0|1|1|160|1|0|1|0|0|1|0|3286|0|1|0|0|0|0|0|0|0|0|0', 'ネチケットを守りましょう。 花札に?係のない?容は予告なく削除する場合があります ' ,
Null, Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), Convert(Int, RAND() * 10), 0, NULL)
SET @ii = @ii+1
End
