Extraor

use [database_name] go set ansi_nulls on go set quoted_identifier on go create procedure PROCEDURE_IMPORT_{upper(table_name)} as begin begin try begin transaction; if ((select count(1) from [temp_table_name])> 0) be...

public string CreateTempTableSql(DataTable sourceDataTable, string sourceTabelName) { var createTempTableSql = string.Empty; try { if (sourceDataTable == null || (string.IsNullOrEmpty(sour...

select b.[name] tableName,a.[name] columnName,c.[name] typeName,a.[length] typeLength ,(case when a.colstat=1 then 1 else 0 end )isIdentity ,(case when a.colstat=4 then 1 else 0 end )isColstat ,(case when isnull(e.[name],'')<>'' then 1 else 0 end) as

分页需求 互联网很多业务都有分页拉取数据的需求，例如： （1）微信消息过多时，拉取第N页消息 （2）京东下单过多时，拉取第N页订单 （3）浏览58同城，查看第N页帖子