生成像下面这样的字段
浙江【年份】001
sql2 = sql2 + "create TRIGGER [" + Text2.text + "_insert] ON [dbo].[" + Text2.text + "] "
sql2 = sql2 + "INSTEAD OF INSERT "
sql2 = sql2 + "AS "
sql2 = sql2 + "declare @str varchar(20) "
sql2 = sql2 + "declare @i integer "
sql2 = sql2 + "set @str = '浙江【" + Text1.text + "】' "
sql2 = sql2 + "select @i=isnull(max(cast(right(rtrim(编号),len(编号)-8) as integer)),0) from "
下面是出错的行,like有语法错误
' sql2 = sql2 + "(select 编号 from " + Text2.text + "where 编号 like @str +'%') a "
sql2 = sql2 + "(select 编号 from " + Text2.text + "where 编号 like @str +'%') a "
sql2 = sql2 + "set @i=@i+1 "
sql2 = sql2 + "INSERT INTO " + Text2.text + ""
sql2 = sql2 + "SELECT @STR++cast(@i as char)as 编号 from inserted"
sql2 = Left(sql2, Len(sql2) - 1)
sql2 = sql2 + ")"
adoConnection.Execute sql2
该怎样改一下
浙江【年份】001
sql2 = sql2 + "create TRIGGER [" + Text2.text + "_insert] ON [dbo].[" + Text2.text + "] "
sql2 = sql2 + "INSTEAD OF INSERT "
sql2 = sql2 + "AS "
sql2 = sql2 + "declare @str varchar(20) "
sql2 = sql2 + "declare @i integer "
sql2 = sql2 + "set @str = '浙江【" + Text1.text + "】' "
sql2 = sql2 + "select @i=isnull(max(cast(right(rtrim(编号),len(编号)-8) as integer)),0) from "
下面是出错的行,like有语法错误
' sql2 = sql2 + "(select 编号 from " + Text2.text + "where 编号 like @str +'%') a "
sql2 = sql2 + "(select 编号 from " + Text2.text + "where 编号 like @str +'%') a "
sql2 = sql2 + "set @i=@i+1 "
sql2 = sql2 + "INSERT INTO " + Text2.text + ""
sql2 = sql2 + "SELECT @STR++cast(@i as char)as 编号 from inserted"
sql2 = Left(sql2, Len(sql2) - 1)
sql2 = sql2 + ")"
adoConnection.Execute sql2
该怎样改一下
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货