SQL 批量插入和更改数据
批量插入数据：1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
declare @i int
set @i = 12
while @i < 14
begin
INSERT INTO ..
(
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,)
VALUES
(@i
,'35 698206 450366 6'
,'64:9A:BE:85:7E:81'
,'64:9A:BE:85:75:67'
,'2TQ3F2Q4VT69V447KFOP7REQQ4'
,'CF8Q44AA'
,'2015-12-31 01:03:07.993'
,'2015-12-30 23:08:30.497'
,'2015-12-31 01:03:08.323'
,'huifu2@worx.net "huifu2 wen"'
,'2015-12-31 01:03:08.243'
,'ANDROID'
,11
,1
,1
,'2015-12-30 23:09:38.317'
,1
,'2015-12-31 01:03:08.323'
,1
,NULL
,NULL
,0
,0
)
set @i = @i + 1
end
更新数据
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
declare @i int
set @i = 1
while @i < 14
begin
UPDATE ..
SET ACTIVESYNC_ID = 'ActiveSyncChangedFOP7REQQ4'
WHERE ACTIVESYNC_ID = '2TQ3F2Q4VT69V447KFOP7REQQ4'
set @i = @i + 1
end
页:
[1]