質問編集履歴
1
上部にある<code>(コードの挿入)を利用してみました。
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -12,11 +12,13 @@
|
|
|
12
12
|
|
|
13
13
|
|
|
14
14
|
|
|
15
|
+
```
|
|
16
|
+
|
|
15
17
|
USE [A-DB]
|
|
16
18
|
|
|
17
19
|
GO
|
|
18
20
|
|
|
19
|
-
/**
|
|
21
|
+
/** Object: StoredProcedure [dbo].[proc01] Script Date: 2020/07/02 13:44:32 **/
|
|
20
22
|
|
|
21
23
|
SET ANSI_NULLS ON
|
|
22
24
|
|
|
@@ -28,9 +30,9 @@
|
|
|
28
30
|
|
|
29
31
|
ALTER PROCEDURE [dbo].[proc01]
|
|
30
32
|
|
|
31
|
-
|
|
33
|
+
@開始日 [Date],
|
|
32
34
|
|
|
33
|
-
|
|
35
|
+
@終了日 [Date]
|
|
34
36
|
|
|
35
37
|
as
|
|
36
38
|
|
|
@@ -48,13 +50,7 @@
|
|
|
48
50
|
|
|
49
51
|
DECLARE @file [nvarchar](800)
|
|
50
52
|
|
|
51
|
-
|
|
52
|
-
|
|
53
|
-
WHERE Date BETWEEN ''' + CONVERT ( varchar, @開始日, 111 ) + ''' AND ''' +
|
|
54
|
-
|
|
55
|
-
CONVERT ( varchar, @終了日, 111 ) + ''' "
|
|
56
|
-
|
|
57
|
-
queryout D:\data\C.csv -U A-DB -P A-DB -d A-DB -c -S -t,'
|
|
53
|
+
set @file = N'bcp "SELECT * FROM tableB WHERE Date BETWEEN ''' + CONVERT ( varchar, @開始日, 111 ) + ''' AND ''' + CONVERT ( varchar, @終了日, 111 ) + ''' " queryout D:\data\C.csv -U A-DB -P A-DB -d A-DB -c -S -t,'
|
|
58
54
|
|
|
59
55
|
EXEC master..xp_cmdshell @file
|
|
60
56
|
|
|
@@ -66,13 +62,17 @@
|
|
|
66
62
|
|
|
67
63
|
EXEC sp_configure 'xp_cmdshell', 0;
|
|
68
64
|
|
|
69
|
-
RECONFIGURE;
|
|
65
|
+
RECONFIGURE;
|
|
70
66
|
|
|
71
67
|
|
|
68
|
+
|
|
69
|
+
```
|
|
72
70
|
|
|
73
71
|
上記のストアドプロシージャを下記の通り実行すると、
|
|
74
72
|
|
|
75
73
|
|
|
74
|
+
|
|
75
|
+
```
|
|
76
76
|
|
|
77
77
|
USE [A-DB]
|
|
78
78
|
|
|
@@ -89,6 +89,8 @@
|
|
|
89
89
|
SELECT 'Return Value' = @return_value
|
|
90
90
|
|
|
91
91
|
GO
|
|
92
|
+
|
|
93
|
+
```
|
|
92
94
|
|
|
93
95
|
|
|
94
96
|
|