这是sql server 的存储过程吗
要是的话

CREATE PROCEDURE dbo.StoredProcedure1
(
@DataTime datatime(8),
@OprationWay varchar(50), 
@IncomeExpenseClass varchar(50),
@IncomeMoney real(4),
@ExpenseMoney real(4),
@Explanation varchar(100))AS 
    INSERT table1([DataTime], OprationWay, IncomeExpenseClass, IncomeMoney ,
           ExpenseMoney, Explanation)
           values(@DataTime,@OprationWay,@IncomeExpenseClass,... ) 

解决方案 »

  1.   

    我改了一下,大家看还有没有错误,不过可以保存了!
    ALTER PROCEDURE dbo.lab2
    (
    @DataTime  datetime,
    @OprationWay varchar(50), 
    @IncomeExpenseClass varchar(50),
    @IncomeMoney real,
    @ExpenseMoney real,
    @Explanation varchar(100))AS 
        INSERT table1([DataTime], OprationWay, IncomeExpenseClass, IncomeMoney ,
               ExpenseMoney, Explanation)
               values(@DataTime,@OprationWay,@IncomeExpenseClass,@IncomeMoney,@ExpenseMoney,@Explanation)