CREATE PROCEDURE kaoqin_class
@weekno char(10),
@dateno char(12),
@classno char(10),
@kno char(10)
AS
declare @cntk int
declare @cntc int
select @cntk = count(*) from kaoqin where 班号 = 'rtrim(@classno)'
select @cntc = count(*) from class where 班号 = 'rtrim(@classno)'
if @cntk = 0 and @cntc <> 0
insert into kaoqin(周别,日期,班号,学号,姓名,课别)values(@weekno,@dateno,@classno,@classno,@classno,@kno)再试试看,加单引号
@weekno char(10),
@dateno char(12),
@classno char(10),
@kno char(10)
AS
declare @cntk int
declare @cntc int
select @cntk = count(*) from kaoqin where 班号 = 'rtrim(@classno)'
select @cntc = count(*) from class where 班号 = 'rtrim(@classno)'
if @cntk = 0 and @cntc <> 0
insert into kaoqin(周别,日期,班号,学号,姓名,课别)values(@weekno,@dateno,@classno,@classno,@classno,@kno)再试试看,加单引号
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货