34,874
社区成员
发帖
与我相关
我的任务
分享请教一insert 语句！
CREATE proc lsp_ModifiedSUBBooking_new
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int,
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert into Bookings_SUB (RoutingID, UserFor)
select RoutingID, UserID from Routing where RoutingID=@ID
commit tran
end
在这个存储过程中，我要将变量@SubBookingid也插入到表中，这个sql语句该怎么写！谢谢！
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int,
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert into Bookings_SUB (RoutingID, UserFor)
select RoutingID, UserID from Routing where RoutingID=@ID
commit tran
end
在这个存储过程中，我要将变量@SubBookingid也插入到表中，这个sql语句该怎么写！谢谢！
...全文
请发表友善的回复…
发表回复
愉快的登山者 2003-10-27
- 打赏
- 举报
CREATE proc lsp_ModifiedSUBBooking_new
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int,
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert into Bookings_SUB (RoutingID, UserFor, SubBookingid)
select RoutingID, UserID, @SubBookingid from Routing where RoutingID=@ID
commit tran
end
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int,
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert into Bookings_SUB (RoutingID, UserFor, SubBookingid)
select RoutingID, UserID, @SubBookingid from Routing where RoutingID=@ID
commit tran
end
pengdali 2003-10-27
- 打赏
- 举报
CREATE proc lsp_ModifiedSUBBooking_new
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert Bookings_SUB (RoutingID, UserFor,对应的列名)
select RoutingID, UserID,@SubBookingid from Routing where RoutingID=@ID
commit tran
end
@ToDo varchar(10),
@ID int,
@BookiID int,
@SubBookingid int,
@UserID int
as
set nocount on
if @ToDo='Add'
begin
begin tran
insert Bookings_SUB (RoutingID, UserFor,对应的列名)
select RoutingID, UserID,@SubBookingid from Routing where RoutingID=@ID
commit tran
end
