摘要: DECLARE @Service_Id INTSET @Service_Id = 2SELECT TOP 1000 service_id,* FROM dbo.MgtRpt_Inspected_OrderWHERE 1=1AND CASE WHEN @Service_Id=-1 THEN -1 ELSE Service_Id END = @Service_IdORDER BY tran_ser_id DESC 阅读全文
posted @ 2010-12-13 12:30 Benny Ng 阅读(141) 评论(0) 推荐(0) 编辑