帮我看看一段存储过程 该为:declare @sql varcahr(700)@sql='insert '+@TableName+' ........exec(@sql)参数的类型最好用VARCHAR 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 先生啊你的表名是用参数给出的你要用动态执行才可以插入。CREATE PROCEDURE InsertRecToStuClassTab @ClassID char(6), @Gradnumber char(10), @Lesson_Code char(4), @Lesson_Name char(40), @Credite decimal(4,1), @Teacher_no char(4), @Teacher char(12), @Times int, @Time1 char(8), @Time2 char(8), @Time3 char(8), @TimeStr char(40), @ExamType char(8), @Classroom char(8), @Relevant bit, @Rele_LCod char(6), @OnlyOne bit, @IsZhiyuan bit, @Zycode1 char(4), @Zycode2 char(4), @College char(4), @TableName char(20)as begin transaction exec('insert '+@TableName+'values (' +@ClassID+','+@Gradnumber+','+@Lesson_Code+','+@Lesson_Name+','+@Credite+',' +@Teacher_no+','+@Teacher+','+@Times+',' +@Time1+','+@Time2+','+@Time3+','+@TimeStr+','+@ExamType+',' +@Classroom+','+@Relevant+','+@Rele_LCod+','+@OnlyOne+',' +@IsZhiyuan+','+@Zycode1+','+@Zycode2+')') if @@error<>0 begin rollback tran return end commit transaction SQL触发器不起作用 请教高手!异类查询问题! 程序开发时,采用多数据库操作,有什么好处吗? 怎么样去掉小数点有效数字后面的所有0? 怎样辨断列是timestamp类型? 一个查询想做成触发器,不知道怎么做? 表损坏如何修复? 如何将专家系统中的规则(if...then...)在关系数据库中表示!并进行推理! vfp 的系统时间 一个简单的SQL语句问题,对于知道的人真是太简单了!!!!!!!1 数据库REPLICATION 问题请教 登陆问题
你的表名是用参数给出的
你要用动态执行才可以插入。
CREATE PROCEDURE InsertRecToStuClassTab
@ClassID char(6),
@Gradnumber char(10),
@Lesson_Code char(4),
@Lesson_Name char(40),
@Credite decimal(4,1),
@Teacher_no char(4),
@Teacher char(12),
@Times int,
@Time1 char(8),
@Time2 char(8),
@Time3 char(8),
@TimeStr char(40),
@ExamType char(8),
@Classroom char(8),
@Relevant bit,
@Rele_LCod char(6),
@OnlyOne bit,
@IsZhiyuan bit,
@Zycode1 char(4),
@Zycode2 char(4),
@College char(4),
@TableName char(20)
as
begin transaction
exec('insert '+@TableName+'values ('
+@ClassID+','+@Gradnumber+','+@Lesson_Code+','+@Lesson_Name+','+@Credite+','
+@Teacher_no+','+@Teacher+','+@Times+','
+@Time1+','+@Time2+','+@Time3+','+@TimeStr+','+@ExamType+','
+@Classroom+','+@Relevant+','+@Rele_LCod+','+@OnlyOne+','
+@IsZhiyuan+','+@Zycode1+','+@Zycode2+')')
if @@error<>0
begin
rollback tran
return
end
commit transaction