只是语法错误,跟我写的表名称没有什么关系。
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 10
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Procedure prcSC0010a, Line 10
Line 10: Incorrect syntax near ')'.
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 12
Incorrect syntax near the keyword 'else'.
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 16
Incorrect syntax near the keyword 'end'.
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 10
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Procedure prcSC0010a, Line 10
Line 10: Incorrect syntax near ')'.
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 12
Incorrect syntax near the keyword 'else'.
Server: Msg 156, Level 15, State 1, Procedure prcSC0010a, Line 16
Incorrect syntax near the keyword 'end'.
解决方案 »
- 求助。这个SQL语句怎么写。
- 在一个触发器中如何判断是更新了数据还是插入了新数据???????????????????????????????
- 如何提高我分页存储过程的性能
- 一个有关存储过程的问题
- 如何判断两张表的记录完全相同呢,谢谢?
- 想将3个表的数据综合成一个数据集,即新的数据集是表A、B、C数据的集合,SQL该怎么写?
- 如何分别SQL Server2000 里表的主键呀 ???
- MS SQl中是否有Oracle中的Concat函数,谢谢!
- 如何写一个存储过程转换Image类型字段的内容????
- 救命啊
- IF UPDATE (column) 和 IF (COLUMNS_UPDATED()) 的分别?
- 难题
@qjmc char(50),
@qjjg float,
@qjgg char(30),
@qjsl int,
@qjdw char(10),
@qjhwh char(10)
AS
begin
if exist(select * from ck where mc=@qjmc)
update ck set sl=sl+@qjsl,jg=(jg*sl+@qjsl*@qjjg)/(sl+@qjsl) where mc=@qjmc
else
begin
insert into kc
values(@qjmc,@qjsl,@qjjg,@qjgg,@qjdw,@qjhwh)
end
end
GO
if exists(select * from kc where (mc=@qjmc))
@qjmc char(50),
@qjjg float,
@qjgg char(30),
@qjsl int,
@qjdw char(10),
@qjhwh char(10)
AS
begin
if exists(select * from kc where (mc=@qjmc))
update kc set sl=sl+@qjsl,jg=(jg*sl+@qjsl*@qjjg)/(sl+@qjsl) where mc=@qjmc
else
insert into kc values(@qjmc,@qjsl,@qjjg,@qjgg,@qjdw,@qjhwh)
end
GO