摘要:
update Food set FoodTitle=cast(SUBSTRING(FoodTitle,0,PATINDEX('%的%',FoodTitle)) as nvarchar),FoodCode=cast(SUBSTRING(FoodCode,0,PATINDEX('%d%',FoodCode)) as nvarchar)where FoodTitle like '%的%' 阅读全文
摘要:
select dateadd(mi,(datediff(mi,convert(varchar(10),dateadd(ss,-1,CreateOn),120),dateadd(ss,-1,CreateOn))/5)*5,convert(varchar(10),CreateOn,120)) as CreateOnss, count(*) as cnt, MAX(CreateOn),sum(OrderAmt) as OrderAmtdd from SaleOrder where OrderStatus>0 and OrderStatus='2014-01-02' and Cr 阅读全文
摘要:
举几个例子来简单说明 这些例子我引用了Northwind库。1. TOP 表达式 SQL Server 2000的TOP是个固定值,是不是觉得不爽,现在改进了。 --前n名的订单declare @n int set @n = 10 select TOP(@n) * from Orders2. 分页 不知各位过去用SQL Server 2000是怎么分页的,大多都用到了临时表。SQL Server 2005一句话就支持分页,性能据说也非常不错。--按Freight从小到大排序,求20到30行的结果 select * from( select OrderId, Freight, R... 阅读全文