摘要:
MySqlBulkLoader批实现过程:将需要的数据集保存到CSV文件,然后再通过MySqlBulkLoader从CSV文件里面读取数据 以下是实现代码: CsvHelp 1 /// <summary> 2 /// 定义csv文件 3 /// </summary> 4 /// <param nam 阅读全文
摘要:
select a.name,a.[type],b.[definition] FROM sys.all_objects a,sys.sql_modules b where a.is_ms_shipped=0 and a.object_id = b.object_id and a.[type] in ( 阅读全文
摘要:
SELECT A.CID,B.TrueNameinto #UserNameFROM RH_CommuUserRole A WITH(NOLOCK)Left join RH_User B WITH(NOLOCK) on A.UserID=B.id AND A.UType=1WHERE B.UserSt 阅读全文
摘要:
WITH indexInfo as ( SELECT SCHEMA_NAME(t.schema_id) [schema_name],t.name as [table_name],t1.name as [index_name] ,t1.type,t1.type_desc,t1.is_unique,t1 阅读全文