create procedure procname ( 参数1 varchar(20), 参数2 int, .... ) as set nocount on insert into 表A values (参数1,参数2,.....) update 表A set col1=... where selec * from 表A
create procedure procname ( 参数1 varchar(20), 参数2 int, .... ) as set nocount on insert into 表A values (参数1,参数2,.....) update 表A set col1=... where selec * from 表A
create proc test as insert tb select .... update tb set col='1' from ta where tadelete tb where colname ='adf'
create proc pr as begin select ... update ... delete ... end
存儲過程中,不就是sql語句操作嗎
(
参数1 varchar(20),
参数2 int,
....
)
as
set nocount on
insert into 表A values (参数1,参数2,.....)
update 表A set col1=... where
selec * from 表A
(
参数1 varchar(20),
参数2 int,
....
)
as
set nocount on
insert into 表A values (参数1,参数2,.....)
update 表A set col1=... where
selec * from 表A
insert tb select ....
update tb set col='1' from ta where tadelete tb where colname ='adf'
as
begin
select ...
update ...
delete ...
end
as
begin
select 1
end