ifobject_id('TEMPDB..#priceTable')isnotnullbegindroptable#priceTableendcreatetable#priceTable(polineCreatedOndate,pricevarchar(max),itemidvarchar(max),purchaseOrderdocnovarchar(max),)insertinto#priceTableselectmax(poli

U9C的数据查询视图Sqlifobject_id('TEMPDB..#priceTable')isnotnullbegindroptable#priceTableendcreatetable#priceTable(polineCreatedOndate,pricevarchar(max),itemidvarchar(max),purchaseOrderdocnovarchar(max),)insertinto#priceTable