Loading

sql 表声明表变量

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

posted @ 2012-05-31 17:42  Sam Xiao  阅读(12408)  评论(0编辑  收藏  举报