摘要：数据库表结构及数据完整复制(跨数据库)SELECT * INTO test FROM db_test.dbo.user_info数据库表结构及数据完整复制SELECT * INTO test FROM user_info复制表数据insert into test select * from user_info复制部分字段insert into PAY_AI_POS_PARAM (papp_aiid,papp_pos_poundage,papp_pos_cap_fee,papp_pos_default_pay_max_amount,papp_pos_max_amount,papp_order_. 阅读全文

摘要：1.隐式事务(TransactionScope)超出事务范围时 如果没有手动调用Complete()方法,则不会提交事务string strConn = "server=.;uid=sa;pwd=123;database=db_test;"; string strSql = "insert into user_info (name,tel) values ('ee',13590305258)";using (TransactionScope tran = new TransactionScope()) { using (... 阅读全文

摘要：SELECT ai_id,ai_mobile FROM dbo.ACCOUNT_INFO WHERE ai_id IN (SELECT DISTINCT ppi_ai_id FROM dbo.PAY_POS_INFO) AND ai_mobile_is_cfm=10注释: 因为PAY_POS_INFO表中存在多个相同的AIID,所以先去除表PAY_POS_INFO中的重复记录即可 阅读全文