declare @order table(ID int,Name varchar(20))
declare @Detail table(ID int,Price float)
insert into @order(ID,Name) values(1,'aa'),(2,'bb'),(3,'cc')
insert into @Detail(ID,Price) values(1,10.5),(2,12.3),(4,5.9)
select * from @order
select * from @Detail
转载于:https://www.cnblogs.com/xcj26/archive/2012/05/31/2528840.html