有這么一個(gè)存儲過程：
該存儲過程實(shí)現(xiàn)根據(jù)傳入的@TableNum值，動態(tài)的選擇數(shù)據(jù)庫的表。然后執(zhí)行插入工作。一開始時(shí)，在如下代碼中
values
(
????????
'
+@RentWay+
'
,
????????
'
+@City+
'
,
????????
'
+@District+
'
,
????????
'
+@Title+
'
,
????????
'
+@Address+
'
,
????????
'
+@XiaoQu+
'
,
????????
'
+UserID+
'
,
????????
'
+HouseType+
'
在調(diào)試時(shí)出現(xiàn)了很多意想不到的錯(cuò)誤。現(xiàn)在把這個(gè)錯(cuò)誤貼出，用于提醒自己
?1
ALTER
?
PROCEDURE
?
[
dbo
]
.
[
ap_BuyAndSaleAction
]
????
?2
????
@DataAction
?
int
,
?3
????
@ID
?
int
?
=
?
0
,
?4
????
@RentWay
?
nvarchar
(
100
),
?5
????
@City
?
nvarchar
(
100
),
?6
????
@District
?
nvarchar
(
100
),
?7
????
@Title
?
nvarchar
(
100
),
?8
????
@Address
?
nvarchar
(
1000
),
?9
????
@XiaoQu
?
nvarchar
(
100
),
10
--
????@AddTime?datetime,
11
????
@UserID
?
int
,
12
????
@HouseType
?
tinyint
,
13
????
@Money
?
money
,
14
????
@Floor
?
tinyint
,
15
????
@TotalFloor
?
tinyint
,
16
????
@MainJi
?
smallint
,
17
????
@NianDai
?
nvarchar
(
100
),
18
????
@Validity
?
smallint
,
19
????
@ZhongJie
?
tinyint
,
20
????
@ZhuangXiu
?
nvarchar
(
1000
),
21
????
@PayMent
?
nvarchar
(
500
),
22
????
@ChaoXiang
?
nvarchar
(
100
),
23
????
@ChanQuan
?
nvarchar
(
100
),
24
????
@KaiFaShang
?
nvarchar
(
100
),
25
????
@Contact
?
nvarchar
(
100
),
26
????
@Tel
?
varchar
(
20
),
27
????
@Mobile
?
varchar
(
20
),
28
????
@Memo
?
nvarchar
(
max
),
29
????
@Memo1
?
nvarchar
(
50
),
30
????
@Memo2
?
nvarchar
(
50
),
31
????
@Memo3
?
nvarchar
(
50
),
32
????
@Flag
?
tinyint
,
33
????
@TableNum
?
nvarchar
(
20
)
34
AS
35
if
?
@DataAction
=
0
36
BEGIN
37
????
declare
?
@select
?
varchar
(
max
)
38
????
set
?
@select
?
=
?
'
insert?into?[tb_
'
+
rtrim
(
@TableNum
)
+
'
_BuyAndSale]
39
????(
40
????????[RentWay],
41
????????[City],
42
????????[District],
43
????????[Title],
44
????????[Address],
45
????????[XiaoQu],
46
????????[UserID],
47
????????[HouseType],
48
????????[Money],
49
????????[Floor],
50
????????[TotalFloor],
51
????????[MainJi],
52
????????[NianDai],
53
????????[Validity],
54
????????[ZhongJie],
55
????????[ZhuangXiu],
56
????????[PayMent],
57
????????[ChaoXiang],
58
????????[ChanQuan],
59
????????[KaiFaShang],
60
????????[Contact],
61
????????[Tel],
62
????????[Mobile],
63
????????[Memo],
64
????????[Memo1],
65
????????[Memo2],
66
????????[Memo3],
67
????????[Flag]
68
????)?
69
????values(
70
????????
'''
+
@RentWay
+
'''
,
71
????????
'''
+
@City
+
'''
,
72
????????
'''
+
@District
+
'''
,
73
????????
'''
+
@Title
+
'''
,
74
????????
'''
+
@Address
+
'''
,
75
????????
'''
+
@XiaoQu
+
'''
,
76
????????
'
+
rtrim
(
@UserID
)
+
'
,
77
????????
'
+
rtrim
(
@HouseType
)
+
'
,
78
????????
'
+
rtrim
(
@Money
)
+
'
,
79
????????
'
+
rtrim
(
@Floor
)
+
'
,
80
????????
'
+
rtrim
(
@TotalFloor
)
+
'
,
81
????????
'
+
rtrim
(
@MainJi
)
+
'
,
82
????????
'''
+
????
@NianDai
+
'''
,
83
????????
'
+
rtrim
(
@Validity
)
+
'
,
84
????????
'
+
rtrim
(
@ZhongJie
)
+
'
,
85
????????
'''
+
@ZhuangXiu
+
'''
,
86
????????
'''
+
@PayMent
+
'''
,
87
????????
'''
+
@ChaoXiang
+
'''
,
88
????????
'''
+
@ChanQuan
+
'''
,
89
????????
'''
+
@KaiFaShang
+
'''
,
90
????????
'''
+
@Contact
+
'''
,
91
????????
'''
+
@Tel
+
'''
,
92
????????
'''
+
@Mobile
+
'''
,
93
????????
'''
+
@Memo
+
'''
,
94
????????
'''
+
@Memo1
+
'''
,
95
????????
'''
+
@Memo2
+
'''
,
96
????????
'''
+
@Memo3
+
'''
,
97
????????
'
+
rtrim
(
@Flag
)
+
'
)
'
98
?
EXEC
(
@select
)
99
????
set
?
@ID
=
scope_identity
()
ALTER
?
PROCEDURE
?
[
dbo
]
.
[
ap_BuyAndSaleAction
]
????
?2
????
@DataAction
?
int
,
?3
????
@ID
?
int
?
=
?
0
,
?4
????
@RentWay
?
nvarchar
(
100
),
?5
????
@City
?
nvarchar
(
100
),
?6
????
@District
?
nvarchar
(
100
),
?7
????
@Title
?
nvarchar
(
100
),
?8
????
@Address
?
nvarchar
(
1000
),
?9
????
@XiaoQu
?
nvarchar
(
100
),
10
--
????@AddTime?datetime,
11
????
@UserID
?
int
,
12
????
@HouseType
?
tinyint
,
13
????
@Money
?
money
,
14
????
@Floor
?
tinyint
,
15
????
@TotalFloor
?
tinyint
,
16
????
@MainJi
?
smallint
,
17
????
@NianDai
?
nvarchar
(
100
),
18
????
@Validity
?
smallint
,
19
????
@ZhongJie
?
tinyint
,
20
????
@ZhuangXiu
?
nvarchar
(
1000
),
21
????
@PayMent
?
nvarchar
(
500
),
22
????
@ChaoXiang
?
nvarchar
(
100
),
23
????
@ChanQuan
?
nvarchar
(
100
),
24
????
@KaiFaShang
?
nvarchar
(
100
),
25
????
@Contact
?
nvarchar
(
100
),
26
????
@Tel
?
varchar
(
20
),
27
????
@Mobile
?
varchar
(
20
),
28
????
@Memo
?
nvarchar
(
max
),
29
????
@Memo1
?
nvarchar
(
50
),
30
????
@Memo2
?
nvarchar
(
50
),
31
????
@Memo3
?
nvarchar
(
50
),
32
????
@Flag
?
tinyint
,
33
????
@TableNum
?
nvarchar
(
20
)
34
AS
35
if
?
@DataAction
=
0
36
BEGIN
37
????
declare
?
@select
?
varchar
(
max
)
38
????
set
?
@select
?
=
?
'
insert?into?[tb_
'
+
rtrim
(
@TableNum
)
+
'
_BuyAndSale]
39
????(
40
????????[RentWay],
41
????????[City],
42
????????[District],
43
????????[Title],
44
????????[Address],
45
????????[XiaoQu],
46
????????[UserID],
47
????????[HouseType],
48
????????[Money],
49
????????[Floor],
50
????????[TotalFloor],
51
????????[MainJi],
52
????????[NianDai],
53
????????[Validity],
54
????????[ZhongJie],
55
????????[ZhuangXiu],
56
????????[PayMent],
57
????????[ChaoXiang],
58
????????[ChanQuan],
59
????????[KaiFaShang],
60
????????[Contact],
61
????????[Tel],
62
????????[Mobile],
63
????????[Memo],
64
????????[Memo1],
65
????????[Memo2],
66
????????[Memo3],
67
????????[Flag]
68
????)?
69
????values(
70
????????
'''
+
@RentWay
+
'''
,
71
????????
'''
+
@City
+
'''
,
72
????????
'''
+
@District
+
'''
,
73
????????
'''
+
@Title
+
'''
,
74
????????
'''
+
@Address
+
'''
,
75
????????
'''
+
@XiaoQu
+
'''
,
76
????????
'
+
rtrim
(
@UserID
)
+
'
,
77
????????
'
+
rtrim
(
@HouseType
)
+
'
,
78
????????
'
+
rtrim
(
@Money
)
+
'
,
79
????????
'
+
rtrim
(
@Floor
)
+
'
,
80
????????
'
+
rtrim
(
@TotalFloor
)
+
'
,
81
????????
'
+
rtrim
(
@MainJi
)
+
'
,
82
????????
'''
+
????
@NianDai
+
'''
,
83
????????
'
+
rtrim
(
@Validity
)
+
'
,
84
????????
'
+
rtrim
(
@ZhongJie
)
+
'
,
85
????????
'''
+
@ZhuangXiu
+
'''
,
86
????????
'''
+
@PayMent
+
'''
,
87
????????
'''
+
@ChaoXiang
+
'''
,
88
????????
'''
+
@ChanQuan
+
'''
,
89
????????
'''
+
@KaiFaShang
+
'''
,
90
????????
'''
+
@Contact
+
'''
,
91
????????
'''
+
@Tel
+
'''
,
92
????????
'''
+
@Mobile
+
'''
,
93
????????
'''
+
@Memo
+
'''
,
94
????????
'''
+
@Memo1
+
'''
,
95
????????
'''
+
@Memo2
+
'''
,
96
????????
'''
+
@Memo3
+
'''
,
97
????????
'
+
rtrim
(
@Flag
)
+
'
)
'
98
?
EXEC
(
@select
)
99
????
set
?
@ID
=
scope_identity
()
該存儲過程實(shí)現(xiàn)根據(jù)傳入的@TableNum值，動態(tài)的選擇數(shù)據(jù)庫的表。然后執(zhí)行插入工作。一開始時(shí)，在如下代碼中
1
values
(
2
????????
'''
+@RentWay+
'''
,
3
????????
'''
+@City+
'''
,
4
????????
'''
+@District+
'''
,
5
????????
'''
+@Title+
'''
,
6
????????
'''
+@Address+
'''
,
7
????????
'''
+@XiaoQu+
'''
,
8
????????
'
+rtrim(@UserID)+
'
,
9
????????
'
+rtrim(@HouseType)+
'
只是寫成了：
values
(
2
????????
'''
+@RentWay+
'''
,
3
????????
'''
+@City+
'''
,
4
????????
'''
+@District+
'''
,
5
????????
'''
+@Title+
'''
,
6
????????
'''
+@Address+
'''
,
7
????????
'''
+@XiaoQu+
'''
,
8
????????
'
+rtrim(@UserID)+
'
,
9
????????
'
+rtrim(@HouseType)+
'
values
(
????????
'
+@RentWay+
'
,
????????
'
+@City+
'
,
????????
'
+@District+
'
,
????????
'
+@Title+
'
,
????????
'
+@Address+
'
,
????????
'
+@XiaoQu+
'
,
????????
'
+UserID+
'
,
????????
'
+HouseType+
'
更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯(lián)系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點(diǎn)擊下面給點(diǎn)支持吧，站長非常感激您！手機(jī)微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點(diǎn)擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
