奇怪的传值问题

zengzhimin1980 2009-09-11 03:40:41
declare @branch varchar(1000)
set @branch="'AP1','CT2','CW1','CW3','CW4','CW5','FW1','JD2','JD3','KT1','MA3','MA4','MA5','MA6','MK1','MK2','MK3','MK5','MK6','MK7','NP2','NP3','SS1','ST3','ST4','ST5','TF1','TK1','TM1','TM2','TS1','TS2','TS3','TW1','TW2','YL2'"

这样传值会提示:"識別項 (訊息) 長度過長。長度上限為 128 " 的错误

请问我应该如何处理?
...全文
42 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
ChinaJiaBing 2009-09-11
  • 打赏
  • 举报
回复

分开相加..
soft_wsx 2009-09-11
  • 打赏
  • 举报
回复
declare @branch varchar(1000) 
set @branch="'AP1','CT2','CW1','CW3','CW4','CW5','FW1','JD2','JD3','KT1','MA3',
'MA4','MA5','MA6','MK1','MK2','MK3','MK5','MK6','MK7','NP2','NP3','SS1','ST3',
'ST4','ST5','TF1','TK1','TM1','TM2','TS1','TS2','TS3','TW1','TW2','YL2'"
soft_wsx 2009-09-11
  • 打赏
  • 举报
回复
declare @branch varchar(1000) 
set @branch=@branch+"'AP1','CT2','CW1','CW3','CW4','CW5','FW1','JD2','JD3','KT1','MA3','MA4','MA5','MA6','MK1','MK2','MK3','MK5','MK6','MK7','NP2','NP3','SS1','ST3','ST4','ST5','TF1','TK1','TM1','TM2','TS1','TS2','TS3','TW1','TW2','YL2'"
SQL77 2009-09-11
  • 打赏
  • 举报
回复
分两个加起来