斌斌的博客

摘要： select *,ROW_NUMBER() OVER(PARTITION BY FItemID ORDER BY FOrderPrice) as num into #t1 from ICStockBillEntry where finterid=@interid--select * into #t2 from #t1 where num=1 阅读全文

摘要： Some Useful ExamplesString.Format("{0:＄#,##0.00;(＄#,##0.00);Zero}", value);This will output "＄1,240.00" if passed 1243.50. It will output the same format but in parentheses if the number is negative, and will output the string "Zero" if the number is zero.String.Format( 阅读全文