05 2012 档案

摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Collections;using System.Reflection;namespace DatableToList{ class ConvertHelper<T> where T : new() { /// <summary> /// 利用反射和泛型 /// </summary> /// <param... 阅读全文

摘要：1.创建存储过程CREATE PROCEDURE [dbo].[sp_generate_insert_script] ( @table_name NVARCHAR(128), --表名 @condition NVARCHAR(128) --查询条件WHERE 语句)ASDECLARE @column_list varchar(8000)DECLARE @values_list varchar(8000)DECLARE @sql varchar(8000)DECLARE @msg varchar(8000)CREATE TABLE #result(sql v... 阅读全文