全哥

摘要： 1\批量导入数据DimbcAsNewSystem.Data.SqlClient.SqlBulkCopy(conn)bc.DestinationTableName="tbl1"?这个是对整个表加了锁?还是?2\批量更新数据update tbl1 set a.name=b.name ,a.sex=b.sex from tbl1 as a inner join (select name,sex from... 阅读全文

摘要： 所有对象：SELECT name, object_id, principal_id, schema_id, parent_object_id, type, type_desc, create_date, modify_date, is_ms_shipped, is_published, is_schema_publishedFROM sys.all_objectsORDER BY name索引对... 阅读全文