22,302
社区成员




print CHARINDEX(',',@ENDS)+1 ---加这四句看看 ,哪个不对
print CHARINDEX(',',@START)+1
print CHARINDEX(',',@EDATE)+1
print CHARINDEX(',',@EYEAR)+1
SET @ENDS=SUBSTRING(@ENDS,CHARINDEX(',',@ENDS)+1,8000)
SET @START=SUBSTRING(@START,CHARINDEX(',',@START)+1,8000)
SET @EDATE=SUBSTRING(@EDATE,CHARINDEX(',',@EDATE)+1,8000)
SET @EYEAR=SUBSTRING(@EYEAR,CHARINDEX(',',@EYEAR)+1,8000)
SET @NUMS=CHARINDEX(',',@START)
END
IF @@ERROR = 0
COMMIT TRANSACTION
ELSE
ROLLBACK TRANSACTION
GO