polly study cs

posts - 34, comments - 0, trackbacks - 0, articles - 1

:: 管理

2011.5.5 SQL语句实践

Posted on 2011-05-05 17:12 polly 阅读(170) 评论(0) 编辑收藏引用

select * from R_Business_OrderInfo
2

select *from Base_ProductInfo
4

select *from Base_ProductInfo where ProLine_Name='服务器'
6

select *from Base_ProductInfo where ProLine_Name='服务器' and Product_BaseTypeName='电话支持类'
8

select top 10 *from Base_ProductInfo order by newid()
10

select top 10 * from Base_ProductInfo where ProLine_Name='服务器' order by CreateDate asc
12

select * from Base_ProductInfo where Product_BigTypeName like '硬盘%'
14

select * from R_Business_OrderInfo
16

select * from R_Business_OrderInfo where UnifiedCustName like '[中深]%' order by SVC_MaterialName
18

alter table T_Base_Rate
20

alter column Ratetype varchar(50)
21

select *from Base_ProductInfo
23

select * from T_Base_StandardDate
25

--查询表的主键
27

EXEC sp_pkeys @table_name='R_Business_OrderInfo'
28

--查询表的主键
29

select * from R_Business_OrderInfo

只有注册用户登录后才能发表评论。




网站导航: 博客园 IT新闻 BlogJava 知识库博问管理