Declare @BarCode varchar(Max),@BarCodeCur nvarchar(16),@Id int
set @BarCode = ''
set @BarCodeCur = 'GG141200496095'
set @Id = 1
While @Id <= 550
Begin
set @BarCode = @BarCode + @BarCodeCur + char(10)
Set @Id = @Id + 1
End
print @BarCode
@BarCode 会截断
GG141200496095
GG141
...全文
11025打赏收藏
varchar(Max)变量可以存放多少字符
Declare @BarCode varchar(Max),@BarCodeCur nvarchar(16),@Id int set @BarCode = '' set @BarCodeCur = 'GG141200496095' set @Id = 1 While @Id <= 550 Begin set @BarCode = @BarCode + @BarCodeCur + char(10) Set @Id = @Id + 1 End print @BarCode @BarCode 会截断