create procedure ModCourse
@tablename varchar(80),
@course varchar(50),
@chengji numeric(10,2)
as
declare @sql varchar(300)
set @sql='insert into ' + @tablename + '
(ID,name,course,chengji)
select distinct ID,name,''' + @course + ''',' + cast(@chengji as varchar(20)) + '
from ' + @tablename exec (@sql)
go
@tablename varchar(80),
@course varchar(50),
@chengji numeric(10,2)
as
declare @sql varchar(300)
set @sql='insert into ' + @tablename + '
(ID,name,course,chengji)
select distinct ID,name,''' + @course + ''',' + cast(@chengji as varchar(20)) + '
from ' + @tablename exec (@sql)
go
exec ModCourse 'A980331','英语',70
select distinct ID,name,''' + @course + ''',' +cast.....
@course前面的三个单引号和后面的三个单引号是什么意思??