SQLQuery1.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

create table OrdersEntities
(
	Id int identity(1,1) primary key,
	CreateDateTime datetime not null,
	IsDeleted bit not null,
	Remark varchar(100),
	Address varchar(30) not null
)
go

insert into OrdersEntities values(GETDATE(),'0','1','1')
select *from OrdersEntities
create table OrderDetailEntities
(
	Id int identity(1,1) primary key,
	UserId int references UserEntities(Id),
	OrderId int references OrdersEntities(Id),
	BookId int references BookEntities(Id),
	counts int not null,
	CreateDateTime datetime not null,
	IsDeleted bit not null
)
go


exec sp_executesql N'INSERT [dbo].[OrderDetailEntities]([OrderId], [UserId], [BookId], [counts], [CreateDateTime], [IsDeleted], [Orders_Id])
VALUES (@0, @1, @2, @3, @4, @5, NULL)
SELECT [Id]
FROM [dbo].[OrderDetailEntities]
WHERE @@ROWCOUNT > 0 AND [Id] = scope_identity()',N'@0 int,@1 int,@2 int,@3 int,@4 datetime2(7),@5 bit',@0=1,@1=6,@2=1,@3=1,@4='2020-04-29 11:36:07.6212941',@5=0