LINQ+to+SQL 源代码

use diskrent select top 4 gph ,gpmc,gpyy,gpdj from gpb order by gph ASC

select gpcd as 光盘产地,gpyy as 光盘语言 , avg(gpdj) as 平均价格, sum(qnt) as 光盘总数 from gpb WHERE gph

select gpmc as 光盘名称 ,gpcd as 光盘产地 ,gpsm as 光盘说明 from gpb where gpmc like '[我垂]%'

update gpb_view set 数量=5 where 供货商编号=3 go select * from gpb_view

UPDATE gpb_view SET 语言='英文' WHERE 数量=8

CREATE VIEW dbo.gpb_view1 WITH VIEW_METADATA AS SELECT gpmc AS 光盘名称, gpyy AS 语言, ghsbh AS 供货商编号, qnt AS 数量 FROM dbo.gpb WHER…

delete from gpb_view where 数量=5 go select * from gpb_view

/* 2001年4月9日 09:55:15 User: Server: JERRY Database: diskrent Application: MS SQLEM - Data Tools */ …