摘要: select *from (select row_number() over (order by ousp_id) as rowNum,* from YZOrder_OutStock_Product where outs_no=@order_no)) as t where ... 阅读全文
posted @ 2014-04-25 17:20 lengv10 阅读(5373) 评论(0) 推荐(0) 编辑
摘要: Command对象的ExecuteNonQuery()方法、ExecuteReader()方法及ExecuteScalar()方法的返回值分别为什么?ExecuteNonQuery()为影响的记录行数ExecuteReader()为DataReaderExecuteScalar()为sql语句中第一... 阅读全文
posted @ 2014-04-25 08:34 lengv10 阅读(120) 评论(0) 推荐(0) 编辑