摘要： --select * from @pt_tballcreate proc Asset_QueryMainlistForReport( @pi_Action varchar(100), @pi_PropertyCode varchar(100), @pi_pageIndex INT, @pi_pageSize INT, @po_recordCount BIGINT OUTPUT)as DECLARE @pt_StartRowIndex INT DECLARE @pt_EndRowIndex INTSET @pt_StartRowIndex = (@pi_pageIndex - 1) * @pi_ 阅读全文

摘要： Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1): 05/16/06Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06Select CONVERT(varchar(100), G 阅读全文