求助，运行自定义函数不是自己想要的结果，找不到原因，谢谢

2022-05-20 14:13:45 161 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

shimingxiang2022 墨衍会员 · AI 创作全网分发关注 + 加入社区

vscode打开springboot项目，运行错误提示找不到主类简介最近开始使用vscode开发springboot项目，当我发现vscode加上一些插件几乎可以进行所有编程语言的开发时，我就喜欢上了速度快而且界面简介的vscode，把eclispe和intellj IDEA都丢到一边。网上关于vscode搭建springboot开发环境的教程有很多，不过大多都是在安装了springboot插件和java插件之后，接着进行javaHome和maven的配置... 阅读详情

CREATE FUNCTION [dbo].[TO_ISBN13](@isbn as NVARCHAR(16))
RETURNS NVARCHAR
as
begin
   DECLARE @isbn13 NVARCHAR,
           @check_bit int,
           @isbn10 int,
           @isbn9 int,
           @isbn8 int,
           @isbn7 int,
           @isbn6 int,
           @isbn5 int,
           @isbn4 int,
           @isbn3 int,
           @isbn2 int,
           @isbnsum1 int

   SET   @isbn10=CAST(SUBSTRING(@isbn,1,1) as int)
   SET   @isbn9=CAST(SUBSTRING(@isbn,2,1) as int)
   SET   @isbn8=CAST(SUBSTRING(@isbn,3,1) as int)
   SET   @isbn7=CAST(SUBSTRING(@isbn,4,1) as int)
   SET   @isbn6=CAST(SUBSTRING(@isbn,5,1) as int)
   SET   @isbn5=CAST(SUBSTRING(@isbn,6,1) as int)
   SET   @isbn4=CAST(SUBSTRING(@isbn,7,1) as int)
   SET   @isbn3=CAST(SUBSTRING(@isbn,8,1) as int)
   SET   @isbn2=CAST(SUBSTRING(@isbn,9,1) as int)
   SET    @isbnsum1=(9*1+7*3+8*1+@isbn10*3+@isbn9*1+@isbn8*3+@isbn7*1+@isbn6*3+@isbn5*1+@isbn4*3+@isbn3*1+@isbn2*3)
   SET   @check_bit=10-@isbnsum1%10
   SET   @isbn13='978'+left(@isbn,9)+cast(@check_bit as NVARCHAR)
   RETURN @isbn13
END