这是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,... )
要是的话
则
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,... )
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)